explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 52lq : Slow

Settings
# exclusive inclusive rows x rows loops node
1. 98.953 7,011.096 ↑ 10.5 43 1

GroupAggregate (cost=90,291.640..90,310.810 rows=451 width=228) (actual time=6,786.041..7,011.096 rows=43 loops=1)

  • Group Key: seven.xray, (("hotel_papa".lima ->> 'echo'::text))
  • Buffers: shared hit=5447 read=18853, temp read=2320 written=2324
2. 308.109 6,912.143 ↓ 150.2 67,762 1

Sort (cost=90,291.640..90,292.770 rows=451 width=279) (actual time=6,785.989..6,912.143 rows=67,762 loops=1)

  • Sort Key: seven.xray, (("hotel_papa".lima ->> 'echo'::text))
  • Sort Method: external merge Disk: 18560kB
  • Buffers: shared hit=5447 read=18853, temp read=2320 written=2324
3. 72.093 6,604.034 ↓ 150.2 67,762 1

Hash Right Join (cost=1,071.010..90,271.760 rows=451 width=279) (actual time=970.557..6,604.034 rows=67,762 loops=1)

  • Hash Cond: (("hotel_lima".foxtrot ->> 'hotel_juliet'::text) = (seven.xray)::text)
  • Buffers: shared hit=5447 read=18853
4. 58.919 6,531.849 ↓ 1.1 68,156 1

Gather (cost=1,013.000..89,406.400 rows=63,302 width=268) (actual time=970.452..6,531.849 rows=68,156 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=5423 read=18853
5. 16.088 6,472.930 ↑ 1.2 22,719 3

Hash Join (cost=13.000..82,076.200 rows=26,376 width=268) (actual time=966.575..6,472.930 rows=22,719 loops=3)

  • Hash Cond: ("hotel_papa".papa = "hotel_lima".quebec)
  • Buffers: shared hit=17320 read=56400
6. 6,456.619 6,456.619 ↑ 1.2 22,719 3

Parallel Seq Scan on hotel_papa (cost=0.000..81,730.960 rows=26,376 width=178) (actual time=966.240..6,456.619 rows=22,719 loops=3)

  • Filter: (("india" >= 'bravo'::timestamp with time zone) AND ("india" <= 'alpha'::timestamp with time zone))
  • Rows Removed by Filter: 410678
  • Buffers: shared hit=17206 read=56400
7. 0.116 0.223 ↑ 1.0 311 3

Hash (cost=9.110..9.110 rows=311 width=98) (actual time=0.223..0.223 rows=311 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
  • Buffers: shared hit=18
8. 0.107 0.107 ↑ 1.0 311 3

Seq Scan on hotel_lima (cost=0.000..9.110 rows=311 width=98) (actual time=0.015..0.107 rows=311 loops=3)

  • Buffers: shared hit=18
9. 0.022 0.092 ↓ 10.8 43 1

Hash (cost=57.960..57.960 rows=4 width=73) (actual time=0.092..0.092 rows=43 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=24
10. 0.070 0.070 ↓ 10.8 43 1

Index Scan using two on seven (cost=0.280..57.960 rows=4 width=73) (actual time=0.015..0.070 rows=43 loops=1)

  • Index Cond: (("golf")::text = 'three_papa'::text)
  • Filter: (("three_echo")::text = 'kilo'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=24