explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uluD

Settings
# exclusive inclusive rows x rows loops node
1. 103.386 700.151 ↓ 3,390.6 27,125 1

Sort (cost=35,098.13..35,098.15 rows=8 width=81) (actual time=695.879..700.151 rows=27,125 loops=1)

  • Sort Key: (COALESCE(reserver.text_id, account.text_id)), fuqh.added
  • Sort Method: external merge Disk: 2680kB
  • Buffers: shared hit=98739, temp read=5309 written=5286
2. 28.868 596.765 ↓ 3,390.6 27,125 1

Nested Loop (cost=11,321.44..35,098.01 rows=8 width=81) (actual time=393.624..596.765 rows=27,125 loops=1)

  • Buffers: shared hit=98739, temp read=4974 written=4950
3. 125.809 540.772 ↓ 3,390.6 27,125 1

Hash Join (cost=11,321.14..35,095.19 rows=8 width=86) (actual time=393.607..540.772 rows=27,125 loops=1)

  • Hash Cond: (fuqh.reservation_id = fur.id)
  • Buffers: shared hit=17364, temp read=4974 written=4950
4. 210.773 210.773 ↑ 1.0 34,893 1

Seq Scan on firmware_update_quota_history fuqh (cost=0.00..23,639.64 rows=35,821 width=24) (actual time=188.836..210.773 rows=34,893 loops=1)

  • Filter: ((added < now()) AND (added >= (now() - '30 days'::interval)))
  • Rows Removed by Filter: 624693
  • Buffers: shared hit=8799
5. 96.493 204.190 ↓ 3,265.7 277,584 1

Hash (cost=11,320.08..11,320.08 rows=85 width=70) (actual time=204.190..204.190 rows=277,584 loops=1)

  • Buckets: 65536 (originally 1024) Batches: 16 (originally 1) Memory Usage: 4090kB
  • Buffers: shared hit=8565, temp written=2761
6. 23.722 107.697 ↓ 3,265.7 277,584 1

Gather (cost=1,034.08..11,320.08 rows=85 width=70) (actual time=0.396..107.697 rows=277,584 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=8565
7. 57.132 83.975 ↓ 2,643.7 92,528 3

Hash Join (cost=34.08..10,311.58 rows=35 width=70) (actual time=0.252..83.975 rows=92,528 loops=3)

  • Hash Cond: (fur.reserver_id = reserver.id)
  • Buffers: shared hit=8565
8. 26.654 26.654 ↑ 1.2 128,286 3

Parallel Seq Scan on firmware_update_reservations fur (cost=0.00..9,863.83 rows=157,583 width=41) (actual time=0.012..26.654 rows=128,286 loops=3)

  • Buffers: shared hit=8288
9. 0.010 0.189 ↑ 1.0 25 3

Hash (cost=33.77..33.77 rows=25 width=37) (actual time=0.189..0.189 rows=25 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=221
10. 0.179 0.179 ↑ 1.0 25 3

Index Scan using accounts_pkey on accounts reserver (cost=0.29..33.77 rows=25 width=37) (actual time=0.048..0.179 rows=25 loops=3)

  • Index Cond: (id = ANY ('{1,209,143,246,114,204,167,162,163,230,164,15,19848,58658,3,211,119,4,186,71569,175,170,168,124473,187}'::integer[]))
  • Buffers: shared hit=221
11. 27.125 27.125 ↑ 1.0 1 27,125

Index Scan using accounts_pkey on accounts account (cost=0.29..0.35 rows=1 width=37) (actual time=0.001..0.001 rows=1 loops=27,125)

  • Index Cond: (id = fuqh.account_id)
  • Buffers: shared hit=81375