explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 659l : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 51.949 ↑ 1.0 1 1

Subquery Scan on t (cost=5,441.65..5,441.82 rows=1 width=212) (actual time=51.948..51.949 rows=1 loops=1)

  • Buffers: shared hit=29662
2. 0.053 51.944 ↑ 1.0 1 1

Aggregate (cost=5,441.65..5,441.79 rows=1 width=112) (actual time=51.944..51.944 rows=1 loops=1)

  • Buffers: shared hit=29662
3. 0.075 51.891 ↓ 42.0 42 1

Sort (cost=5,441.65..5,441.66 rows=1 width=156) (actual time=51.887..51.891 rows=42 loops=1)

  • Sort Key: i.ad_format, i.network_type, i.bid_type
  • Sort Method: quicksort Memory: 53kB
  • Buffers: shared hit=29662
4. 0.035 51.816 ↓ 42.0 42 1

Nested Loop (cost=1.69..5,441.64 rows=1 width=156) (actual time=0.299..51.816 rows=42 loops=1)

  • Buffers: shared hit=29660
5. 0.021 51.655 ↓ 42.0 42 1

Nested Loop (cost=1.41..5,439.14 rows=1 width=156) (actual time=0.274..51.655 rows=42 loops=1)

  • Buffers: shared hit=29534
6. 0.024 51.550 ↓ 42.0 42 1

Nested Loop (cost=1.14..5,436.63 rows=1 width=124) (actual time=0.271..51.55 rows=42 loops=1)

  • Buffers: shared hit=29452
7. 0.072 51.400 ↓ 42.0 42 1

Nested Loop (cost=0.85..5,434.09 rows=1 width=96) (actual time=0.266..51.4 rows=42 loops=1)

  • Buffers: shared hit=29368
8. 0.016 50.877 ↓ 41.0 41 1

Append (cost=0.43..5,431.43 rows=1 width=56) (actual time=0.225..50.877 rows=41 loops=1)

  • Buffers: shared hit=29201
9. 50.861 50.861 ↓ 41.0 41 1

Index Scan using exchange_impressions_y2019m09w37_created_at_uuid_idx on exchange_impressions_y2019m09w37 i (cost=0.43..5,431.43 rows=1 width=56) (actual time=0.225..50.861 rows=41 loops=1)

  • Index Cond: ((i.created_at >= '2019-09-10 05:00:00'::timestamp without time zone) AND (i.created_at <= '2019-09-11 04:59:59'::timestamp without time zone))
  • Filter: ((NOT i.excluded) AND (NOT i.expired) AND (i.publisher_website_id = 698))
  • Buffers: shared hit=29201
10. 0.451 0.451 ↑ 1.0 1 41

Index Scan using index_exchange_clicks_on_exchange_impression_id on exchange_clicks ec (cost=0.43..2.65 rows=1 width=44) (actual time=0.011..0.011 rows=1 loops=41)

  • Index Cond: (ec.exchange_impression_id = i.id)
  • Filter: ((ec.created_at >= '2019-09-10 05:00:00'::timestamp without time zone) AND (ec.created_at <= '2019-09-11 04:59:59'::timestamp without time zone))
  • Buffers: shared hit=167
11. 0.126 0.126 ↓ 0.0 0 42

Index Scan using idx_video_views_on_created_at_and_ad_video_and_impression on exchange_video_views evv (cost=0.28..2.53 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=42)

  • Index Cond: ((evv.created_at >= '2019-09-10 05:00:00'::timestamp without time zone) AND (evv.created_at <= '2019-09-11 04:59:59'::timestamp without time zone) AND (evv.exchange_impression_id = i.id))
  • Buffers: shared hit=84
12. 0.084 0.084 ↓ 0.0 0 42

Index Scan using index_exchange_conversions_on_exchange_click_id on exchange_conversions eco (cost=0.28..2.5 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=42)

  • Index Cond: (eco.exchange_click_id = ec.id)
  • Filter: ((eco.created_at >= '2019-09-10 05:00:00'::timestamp without time zone) AND (eco.created_at <= '2019-09-11 04:59:59'::timestamp without time zone))
  • Buffers: shared hit=82
13. 0.126 0.126 ↑ 1.0 1 42

Index Scan using publisher_websites_pkey on publisher_websites publisher_websites (cost=0.27..2.49 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=42)

  • Index Cond: (publisher_websites.id = 698)
  • Filter: ((publisher_websites.status)::text = 'active'::text)
  • Buffers: shared hit=126