explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l3P2

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.885 ↑ 1.0 1 1

Limit (cost=105.88..105.88 rows=1 width=10) (actual time=0.884..0.885 rows=1 loops=1)

2. 0.025 0.883 ↑ 1.0 1 1

Sort (cost=105.88..105.88 rows=1 width=10) (actual time=0.883..0.883 rows=1 loops=1)

  • Sort Key: seq_no
  • Sort Method: quicksort Memory: 25kB
3. 0.858 0.858 ↓ 2.0 2 1

Index Scan using index_ad_media_ad_id on ad_media (cost=0.00..105.87 rows=1 width=10) (actual time=0.834..0.858 rows=2 loops=1)

  • Index Cond: (ad_id = 68,820,852)
  • Filter: (COALESCE(media_type, 'image'::enum_ad_media_media_type) = 'image'::enum_ad_media_media_type)
Total runtime : 0.908 ms