explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VDGH

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 1,192.036 ↑ 1.0 10 1

Limit (cost=9,728.77..9,738.66 rows=10 width=233) (actual time=1,190.120..1,192.036 rows=10 loops=1)

  • Buffers: shared hit=2524 read=3, temp written=1376
2. 0.019 1,192.024 ↑ 27,464.8 10 1

Nested Loop Left Join (cost=9,728.77..281,464.71 rows=274,648 width=233) (actual time=1,190.118..1,192.024 rows=10 loops=1)

  • Buffers: shared hit=2524 read=3, temp written=1376
3. 0.021 1,191.975 ↑ 27,464.8 10 1

Nested Loop (cost=9,728.34..120,980.49 rows=274,648 width=148) (actual time=1,190.100..1,191.975 rows=10 loops=1)

  • Buffers: shared hit=2485 read=2, temp written=1376
4. 16.862 1,190.114 ↑ 27,464.8 10 1

Hash Left Join (cost=9,728.06..37,882.94 rows=274,648 width=127) (actual time=1,190.007..1,190.114 rows=10 loops=1)

  • Hash Cond: (t5.event_id = t3.event_id)
  • Buffers: shared hit=2454, temp written=1376
5. 0.322 201.132 ↑ 3,613.8 76 1

Hash Join (cost=1,478.42..16,227.06 rows=274,648 width=101) (actual time=201.023..201.132 rows=76 loops=1)

  • Hash Cond: (t5.city_id = t2.city_id)
  • Buffers: shared hit=655
6. 0.034 0.034 ↑ 3,614.5 76 1

Seq Scan on tn_events t5 (cost=0.00..10,972.03 rows=274,703 width=78) (actual time=0.006..0.034 rows=76 loops=1)

  • Buffers: shared hit=3
7. 81.620 200.776 ↑ 1.0 36,863 1

Hash (cost=1,017.63..1,017.63 rows=36,863 width=31) (actual time=200.776..200.776 rows=36,863 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2890kB
  • Buffers: shared hit=649
8. 119.156 119.156 ↑ 1.0 36,863 1

Seq Scan on mv_city_state_country t2 (cost=0.00..1,017.63 rows=36,863 width=31) (actual time=0.009..119.156 rows=36,863 loops=1)

  • Buffers: shared hit=649
9. 585.333 972.120 ↑ 1.0 212,873 1

Hash (cost=3,924.73..3,924.73 rows=212,873 width=34) (actual time=972.119..972.120 rows=212,873 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 2399kB
  • Buffers: shared hit=1796, temp written=1376
10. 386.787 386.787 ↑ 1.0 212,873 1

Seq Scan on mv_event_performers t3 (cost=0.00..3,924.73 rows=212,873 width=34) (actual time=0.015..386.787 rows=212,873 loops=1)

  • Buffers: shared hit=1796
11. 1.840 1.840 ↑ 1.0 1 10

Index Scan using tn_venues_pkey on tn_venues t1 (cost=0.28..0.30 rows=1 width=33) (actual time=0.184..0.184 rows=1 loops=10)

  • Index Cond: (venue_id = t5.venue_id)
  • Buffers: shared hit=31 read=2
12. 0.030 0.030 ↑ 1.0 1 10

Index Scan using idx_cat on mv_cat_path t4 (cost=0.42..0.57 rows=1 width=101) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (category_id = t5.category_id)
  • Buffers: shared hit=39 read=1
Planning time : 58.378 ms
Execution time : 1,203.510 ms