explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SAtK

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 1,516.501 ↑ 1.0 4 1

Limit (cost=22,416.82..22,416.83 rows=4 width=155) (actual time=1,516.494..1,516.501 rows=4 loops=1)

  • Buffers: shared hit=31243
2. 14.768 1,516.494 ↑ 1,226.5 4 1

Sort (cost=22,416.82..22,429.09 rows=4,906 width=155) (actual time=1,516.493..1,516.494 rows=4 loops=1)

  • Sort Key: t5.event_date
  • Sort Method: top-N heapsort Memory: 26kB
  • Buffers: shared hit=31243
3. 46.513 1,501.726 ↓ 7.5 36,913 1

Merge Join (cost=20,013.20..22,343.23 rows=4,906 width=155) (actual time=136.494..1,501.726 rows=36,913 loops=1)

  • Merge Cond: (t4.category_id = t5.category_id)
  • Buffers: shared hit=31243
4. 1,293.611 1,293.611 ↑ 168.7 94 1

Index Scan using idx_cat on mv_cat_path t4 (cost=0.42..45,534.55 rows=15,860 width=101) (actual time=0.022..1,293.611 rows=94 loops=1)

  • Filter: ('concerts'::text ~~* ANY (categories))
  • Rows Removed by Filter: 324315
  • Buffers: shared hit=23018
5. 85.801 161.602 ↑ 1.0 98,350 1

Sort (cost=19,996.02..20,246.91 rows=100,359 width=70) (actual time=134.814..161.602 rows=98,350 loops=1)

  • Sort Key: t5.category_id
  • Sort Method: quicksort Memory: 17233kB
  • Buffers: shared hit=8225
6. 75.801 75.801 ↑ 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.010..75.801 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