explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HThT

Settings
# exclusive inclusive rows x rows loops node
1. 0.092 1,114.247 ↑ 1.0 4 1

Limit (cost=33,022.01..33,022.02 rows=4 width=233) (actual time=1,114.156..1,114.247 rows=4 loops=1)

  • Buffers: shared hit=19157, temp read=1111 written=1109
2. 19.660 1,114.155 ↑ 1,226.2 4 1

Sort (cost=33,022.01..33,034.27 rows=4,905 width=233) (actual time=1,114.154..1,114.155 rows=4 loops=1)

  • Sort Key: t5.event_date DESC
  • Sort Method: top-N heapsort Memory: 27kB
  • Buffers: shared hit=19157, temp read=1111 written=1109
3. 22.514 1,094.495 ↓ 7.5 36,913 1

Hash Join (cost=28,174.54..32,948.44 rows=4,905 width=233) (actual time=905.733..1,094.495 rows=36,913 loops=1)

  • Hash Cond: (t5.venue_id = t1.venue_id)
  • Buffers: shared hit=19157, temp read=1111 written=1109
4. 115.076 1,066.449 ↓ 7.5 36,913 1

Hash Right Join (cost=27,848.96..32,609.97 rows=4,905 width=220) (actual time=900.159..1,066.449 rows=36,913 loops=1)

  • Hash Cond: (t3.event_id = t5.event_id)
  • Buffers: shared hit=19008, temp read=1111 written=1109
5. 57.183 57.183 ↑ 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.008..57.183 rows=212,873 loops=1)

  • Buffers: shared hit=1796
6. 30.340 894.190 ↓ 7.5 36,913 1

Hash (cost=27,787.64..27,787.64 rows=4,905 width=194) (actual time=894.189..894.190 rows=36,913 loops=1)

  • Buckets: 32768 (originally 8192) Batches: 2 (originally 1) Memory Usage: 3841kB
  • Buffers: shared hit=17212, temp written=396
7. 28.870 863.850 ↓ 7.5 36,913 1

Hash Join (cost=15,636.00..27,787.64 rows=4,905 width=194) (actual time=725.423..863.850 rows=36,913 loops=1)

  • Hash Cond: (t5.city_id = t2.city_id)
  • Buffers: shared hit=17212
8. 36.304 806.793 ↓ 7.5 36,913 1

Hash Join (cost=14,157.58..26,241.78 rows=4,906 width=171) (actual time=696.980..806.793 rows=36,913 loops=1)

  • Hash Cond: (t5.category_id = t4.category_id)
  • Buffers: shared hit=16563
9. 73.604 73.604 ↑ 1.0 98,928 1

Seq Scan on tn_events t5 (cost=0.00..11,658.79 rows=100,359 width=78) (actual time=0.009..73.604 rows=98,928 loops=1)

  • Filter: (is_enable AND (NOT is_cancelled) AND (event_date_offset >= '2019-04-11 03:27:13.326'::timestamp without time zone))
  • Rows Removed by Filter: 175775
  • Buffers: shared hit=8225
10. 0.000 696.885 ↑ 168.7 94 1

Hash (cost=13,959.33..13,959.33 rows=15,860 width=101) (actual time=696.885..696.885 rows=94 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 137kB
  • Buffers: shared hit=8338
11. 7.168 696.909 ↑ 168.7 94 1

Gather (cost=1,000.00..13,959.33 rows=15,860 width=101) (actual time=694.578..696.909 rows=94 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=8338
12. 689.741 689.741 ↑ 213.2 31 3

Parallel Seq Scan on mv_cat_path t4 (cost=0.00..11,373.33 rows=6,608 width=101) (actual time=455.324..689.741 rows=31 loops=3)

  • Filter: ('concerts'::text ~~* ANY (categories))
  • Rows Removed by Filter: 108105
  • Buffers: shared hit=8338
13. 14.675 28.187 ↑ 1.0 36,863 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2890kB
  • Buffers: shared hit=649
14. 13.512 13.512 ↑ 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.007..13.512 rows=36,863 loops=1)

  • Buffers: shared hit=649
15. 2.897 5.532 ↑ 1.0 7,848 1

Hash (cost=227.48..227.48 rows=7,848 width=33) (actual time=5.532..5.532 rows=7,848 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 591kB
  • Buffers: shared hit=149
16. 2.635 2.635 ↑ 1.0 7,848 1

Seq Scan on tn_venues t1 (cost=0.00..227.48 rows=7,848 width=33) (actual time=0.008..2.635 rows=7,848 loops=1)

  • Buffers: shared hit=149