explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.409 7.824 ↓ 13.9 2,093 1

Nested Loop (cost=254.50..446.64 rows=151 width=16) (actual time=2.642..7.824 rows=2,093 loops=1)

2. 0.505 4.322 ↓ 13.9 2,093 1

Hash Join (cost=254.22..306.50 rows=151 width=20) (actual time=2.628..4.322 rows=2,093 loops=1)

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

Hash Join (cost=232.27..280.06 rows=265 width=16) (actual time=2.455..3.652 rows=1,972 loops=1)

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

Index Scan using cm_index_date on checkpointmessages (cost=0.29..45.91 rows=828 width=12) (actual time=0.049..0.606 rows=1,972 loops=1)

  • Index Cond: ((cm_date >= 1560016870) AND (cm_date <= 1562608879))
5. 0.908 2.394 ↑ 1.0 2,880 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 145kB
6. 1.486 1.486 ↑ 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.015..1.486 rows=2,880 loops=1)

7. 0.062 0.165 ↑ 1.0 195 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
8. 0.074 0.103 ↑ 1.0 195 1

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

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

Bitmap Index Scan on zn_unique_row (cost=0.00..10.03 rows=195 width=0) (actual time=0.029..0.029 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 : 1.319 ms