explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qwrC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.005 ↓ 0.0 0 1

Limit (cost=1.15..2,184.94 rows=1 width=2,083) (actual time=0.005..0.005 rows=0 loops=1)

2. 0.001 0.005 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.15..2,184.94 rows=1 width=2,083) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((u0.unit_scraper_id IS NULL) OR (NOT u2.is_autogenerated))
3. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.87..2,184.33 rows=1 width=2,083) (actual time=0.004..0.004 rows=0 loops=1)

4. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using media_items_published_date_index on media_items m1 (cost=0.43..2,155.13 rows=11 width=1,145) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((published_date >= 1554224400) AND (published_date <= 1554915599))
  • Filter: ((country_id)::text[] && '{IDN}'::text[])
5. 0.000 0.000 ↓ 0.0 0

Index Scan using unit_media_items_media_item_id_index on unit_media_items u0 (cost=0.43..2.66 rows=1 width=938) (never executed)

  • Index Cond: (media_item_id = m1.id)
  • Filter: ((domain_unit_id = '7289769a-1de7-4e1e-ab8e-523d796a70fb'::uuid) AND ((status)::text = 'released'::text))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using unit_scrapers_pkey on unit_scrapers u2 (cost=0.29..0.60 rows=1 width=17) (never executed)

  • Index Cond: (id = u0.unit_scraper_id)
Planning time : 1.627 ms
Execution time : 0.047 ms