explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Abm5

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 2,568.620 ↑ 1.0 1 1

Limit (cost=1,041.10..1,041.11 rows=1 width=10) (actual time=2,568.618..2,568.620 rows=1 loops=1)

2. 0.012 2,568.616 ↑ 1.0 1 1

Sort (cost=1,041.10..1,041.11 rows=1 width=10) (actual time=2,568.616..2,568.616 rows=1 loops=1)

  • Sort Key: seq_no
  • Sort Method: quicksort Memory: 25kB
3. 2,568.604 2,568.604 ↑ 1.0 1 1

Index Scan using index_ad_media_media_type_ad_id on ad_media (cost=0.00..1,041.09 rows=1 width=10) (actual time=2,546.971..2,568.604 rows=1 loops=1)

  • Index Cond: (ad_id = 68,820,852)
Total runtime : 2,568.670 ms