explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N88B

Settings
# exclusive inclusive rows x rows loops node
1. 0.099 48,682.704 ↑ 1.0 10 1

Limit (cost=23,885.93..23,917.82 rows=10 width=233) (actual time=48,624.672..48,682.704 rows=10 loops=1)

2. 0.031 48,682.605 ↑ 490.6 10 1

Nested Loop (cost=23,885.93..39,533.94 rows=4,906 width=233) (actual time=48,624.670..48,682.605 rows=10 loops=1)

3. 0.474 48,625.034 ↑ 490.6 10 1

Hash Left Join (cost=23,885.64..38,027.76 rows=4,906 width=220) (actual time=48,624.646..48,625.034 rows=10 loops=1)

  • Hash Cond: (t5.event_id = t3.event_id)
4. 14.116 31,533.812 ↑ 71.1 69 1

Hash Join (cost=15,636.00..27,787.70 rows=4,906 width=194) (actual time=31,533.477..31,533.812 rows=69 loops=1)

  • Hash Cond: (t5.city_id = t2.city_id)
5. 0.188 31,107.485 ↑ 71.1 69 1

Hash Join (cost=14,157.58..26,241.82 rows=4,907 width=171) (actual time=31,107.232..31,107.485 rows=69 loops=1)

  • Hash Cond: (t5.category_id = t4.category_id)
6. 0.159 0.159 ↑ 333.4 301 1

Seq Scan on tn_events t5 (cost=0.00..11,658.79 rows=100,367 width=78) (actual time=0.010..0.159 rows=301 loops=1)

  • Filter: (is_enable AND (NOT is_cancelled) AND (event_date_offset >= '2019-04-11 03:08:54.867'::timestamp without time zone))
  • Rows Removed by Filter: 32
7. 0.000 31,107.138 ↑ 168.7 94 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 137kB
8. 0.404 31,107.141 ↑ 168.7 94 1

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

  • Workers Planned: 2
  • Workers Launched: 0
9. 31,106.737 31,106.737 ↑ 70.3 94 1

Parallel Seq Scan on mv_cat_path t4 (cost=0.00..11,373.33 rows=6,608 width=101) (actual time=58.254..31,106.737 rows=94 loops=1)

  • Filter: ('concerts'::text ~~* ANY (categories))
  • Rows Removed by Filter: 324315
10. 267.004 412.211 ↑ 1.0 36,863 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2890kB
11. 145.207 145.207 ↑ 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.008..145.207 rows=36,863 loops=1)

12. 9,139.833 17,090.748 ↑ 1.0 212,873 1

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

  • Buckets: 65536 Batches: 8 Memory Usage: 2399kB
13. 7,950.915 7,950.915 ↑ 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.010..7,950.915 rows=212,873 loops=1)

14. 57.540 57.540 ↑ 1.0 1 10

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

  • Index Cond: (venue_id = t5.venue_id)