explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7GfD

Settings
# exclusive inclusive rows x rows loops node
1. 0.106 981.194 ↑ 1.0 4 1

Limit (cost=26,315.37..26,315.38 rows=4 width=155) (actual time=981.089..981.194 rows=4 loops=1)

  • Buffers: shared hit=3420 read=13143
2. 15.586 981.088 ↑ 1,226.5 4 1

Sort (cost=26,315.37..26,327.63 rows=4,906 width=155) (actual time=981.087..981.088 rows=4 loops=1)

  • Sort Key: t5.event_date
  • Sort Method: top-N heapsort Memory: 26kB
  • Buffers: shared hit=3420 read=13143
3. 35.807 965.502 ↓ 7.5 36,913 1

Hash Join (cost=14,157.58..26,241.78 rows=4,906 width=155) (actual time=839.398..965.502 rows=36,913 loops=1)

  • Hash Cond: (t5.category_id = t4.category_id)
  • Buffers: shared hit=3420 read=13143
4. 90.398 90.398 ↑ 1.0 98,928 1

Seq Scan on tn_events t5 (cost=0.00..11,658.79 rows=100,359 width=70) (actual time=0.008..90.398 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=2680 read=5545
5. 0.000 839.297 ↑ 168.7 94 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 137kB
  • Buffers: shared hit=740 read=7598
6. 8.025 839.345 ↑ 168.7 94 1

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

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=740 read=7598
7. 831.320 831.320 ↑ 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=279.070..831.320 rows=31 loops=3)

  • Filter: ('concerts'::text ~~* ANY (categories))
  • Rows Removed by Filter: 108105
  • Buffers: shared hit=740 read=7598