explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.259 11.451 ↓ 13.9 2,093 1

Nested Loop (cost=246.20..1,756.61 rows=151 width=16) (actual time=6.789..11.451 rows=2,093 loops=1)

2. 0.477 8.099 ↓ 13.9 2,093 1

Hash Join (cost=245.92..1,617.52 rows=151 width=20) (actual time=6.778..8.099 rows=2,093 loops=1)

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

Hash Join (cost=223.98..1,591.08 rows=265 width=16) (actual time=6.684..7.534 rows=1,972 loops=1)

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

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

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

Hash (cost=187.98..187.98 rows=2,880 width=8) (actual time=1.201..1.202 rows=2,880 loops=1)

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

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

7. 0.029 0.088 ↑ 1.0 195 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
8. 0.040 0.059 ↑ 1.0 195 1

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

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

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