explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XqVk

Settings
# exclusive inclusive rows x rows loops node
1. 45.029 4,179.386 ↓ 0.0 0 1

Gather (cost=7,914.25..574,838.10 rows=1 width=8) (actual time=4,142.675..4,179.386 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 1,261.471 4,134.357 ↓ 0.0 0 5

Nested Loop (cost=6,914.25..573,838.00 rows=1 width=8) (actual time=4,134.357..4,134.357 rows=0 loops=5)

3. 924.006 2,872.851 ↓ 2.5 34,434 5

Hash Join (cost=6,913.68..565,041.51 rows=13,698 width=8) (actual time=44.305..2,872.851 rows=34,434 loops=5)

  • Hash Cond: (rna.recipient_id = r.recipient_id)
4. 1,904.940 1,904.940 ↑ 1.2 4,425,984 5

Parallel Seq Scan on recipient_ntfn_arc rna (cost=0.00..543,604.81 rows=5,532,480 width=16) (actual time=0.021..1,904.940 rows=4,425,984 loops=5)

5. 1.099 43.905 ↓ 4.6 2,766 5

Hash (cost=6,906.10..6,906.10 rows=607 width=8) (actual time=43.905..43.905 rows=2,766 loops=5)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 141kB
6. 40.339 42.806 ↓ 4.6 2,766 5

Bitmap Heap Scan on recipients r (cost=379.08..6,906.10 rows=607 width=8) (actual time=3.008..42.806 rows=2,766 loops=5)

  • Recheck Cond: ((recipient_cat)::text = 'GROUP'::text)
  • Filter: (upper((target_name)::text) ~~ 'C%'::text)
  • Rows Removed by Filter: 6984
  • Heap Blocks: exact=3474
7. 2.467 2.467 ↓ 1.0 9,760 5

Bitmap Index Scan on idx_recipients_recipient_cat (cost=0.00..378.93 rows=9,668 width=0) (actual time=2.467..2.467 rows=9,760 loops=5)

  • Index Cond: ((recipient_cat)::text = 'GROUP'::text)
8. 0.035 0.035 ↓ 0.0 0 172,169

Index Scan using ntfn_arc_pk on ntfn_arc na (cost=0.56..0.64 rows=1 width=16) (actual time=0.035..0.035 rows=0 loops=172,169)

  • Index Cond: (ntfn_id = rna.ntfn_id)
  • Filter: (ev_id = 102116399)
  • Rows Removed by Filter: 1
Planning time : 1.460 ms
Execution time : 4,179.522 ms