explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hAQs4

Settings
# exclusive inclusive rows x rows loops node
1. 47.985 4,074.161 ↓ 0.0 0 1

Gather (cost=7,914.25..572,215.51 rows=1 width=8) (actual time=4,034.952..4,074.161 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 939.450 4,026.176 ↓ 0.0 0 5

Nested Loop (cost=6,914.25..571,215.41 rows=1 width=8) (actual time=4,026.175..4,026.176 rows=0 loops=5)

3. 808.862 3,086.700 ↓ 2.6 34,434 5

Hash Join (cost=6,913.68..562,688.06 rows=13,236 width=8) (actual time=79.232..3,086.700 rows=34,434 loops=5)

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

Parallel Seq Scan on recipient_ntfn_arc rna (cost=0.00..541,740.70 rows=5,346,070 width=16) (actual time=0.025..2,232.795 rows=4,425,984 loops=5)

5. 1.041 45.043 ↓ 4.6 2,766 5

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

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

Bitmap Heap Scan on recipients r (cost=379.08..6,906.10 rows=607 width=8) (actual time=3.445..44.002 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.802 2.802 ↓ 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.802..2.802 rows=9,760 loops=5)

  • Index Cond: ((recipient_cat)::text = 'GROUP'::text)
8. 0.026 0.026 ↓ 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.026..0.026 rows=0 loops=172,169)

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