Execution time: 501ms
Planning time: 0.089ms
Triggers: N/A
#1 Limit
#2 Sort
#3  └ Seq Scan

Limit

Sort

by id_post

Seq Scan

on posts
 Limit  (cost=153694.51..153694.53 rows=10 width=115) (actual time=500.525..500.528 rows=10 loops=1)
   ->  Sort  (cost=153694.51..153696.95 rows=979 width=115) (actual time=500.524..500.525 rows=10 loops=1)
         Sort Key: id_post
         Sort Method: top-N heapsort  Memory: 27kB
         ->  Seq Scan on posts  (cost=0.00..153673.35 rows=979 width=115) (actual time=1.300..500.442 rows=1000 loops=1)
               Filter: (id_article = 12)
               Rows Removed by Filter: 4999000
 Planning Time: 0.089 ms
 Execution Time: 500.549 ms
Table Count Time
posts 1 500ms 100%
#3 Seq Scan 500ms 100%
Function Count Time
No function used
Node Type Count Time
Seq Scan 1 500ms 100%
#3 Seq Scan 500ms 100%
Sort 1 0.083ms 0%
#2 Sort 0.083ms 0%
Limit 1 0.003ms 0%
#1 Limit 0.003ms 0%
Index Count Time
No index used