explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NfMu : Optimization for: Optimization for: plan #wkr3; plan #fEQem

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.321 11.683 ↓ 13.9 2,093 1

Nested Loop (cost=254.20..1,765.66 rows=151 width=16) (actual time=6.913..11.683 rows=2,093 loops=1)

2. 0.492 8.269 ↓ 13.9 2,093 1

Hash Join (cost=253.92..1,625.52 rows=151 width=20) (actual time=6.895..8.269 rows=2,093 loops=1)

  • Hash Cond: (checkpointmessages.cm_nl_entry_id = zonenodes.zn_nl_id)
3. 0.545 7.685 ↓ 7.4 1,972 1

Hash Join (cost=231.98..1,599.08 rows=265 width=16) (actual time=6.795..7.685 rows=1,972 loops=1)

  • Hash Cond: (checkpointmessages.cm_nl_mobile_id = nodeslogical.nl_id)
4. 5.877 5.877 ↓ 2.4 1,972 1

Seq Scan on checkpointmessages (cost=0.00..1,364.93 rows=828 width=12) (actual time=5.520..5.877 rows=1,972 loops=1)

  • Filter: ((cm_date >= 1560016870) AND (cm_date <= 1562608879))
  • Rows Removed by Filter: 64890
5. 0.441 1.263 ↑ 1.0 2,880 1

Hash (cost=195.98..195.98 rows=2,880 width=8) (actual time=1.263..1.263 rows=2,880 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 145kB
6. 0.822 0.822 ↑ 1.0 2,880 1

Index Scan using nl_index_isactive on nodeslogical (cost=0.28..195.98 rows=2,880 width=8) (actual time=0.012..0.822 rows=2,880 loops=1)

7. 0.030 0.092 ↑ 1.0 195 1

Hash (cost=19.51..19.51 rows=195 width=8) (actual time=0.092..0.092 rows=195 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
8. 0.041 0.062 ↑ 1.0 195 1

Bitmap Heap Scan on zonenodes (cost=10.07..19.51 rows=195 width=8) (actual time=0.034..0.062 rows=195 loops=1)

  • Recheck Cond: (zn_z_id = ANY ('{18,19}'::integer[]))
  • Heap Blocks: exact=2
9. 0.021 0.021 ↑ 1.0 195 1

Bitmap Index Scan on zn_unique_row (cost=0.00..10.03 rows=195 width=0) (actual time=0.021..0.021 rows=195 loops=1)

  • Index Cond: (zn_z_id = ANY ('{18,19}'::integer[]))
10. 2.093 2.093 ↑ 1.0 1 2,093

Index Only Scan using nodesphysical_pkey on nodesphysical (cost=0.28..0.93 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=2,093)

  • Index Cond: (np_id = nodeslogical.nl_np_id)
  • Heap Fetches: 2093
Planning time : 0.782 ms