explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wkr3

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 5.384 ↓ 0.0 0 1

Nested Loop (cost=13.18..1,388.18 rows=2 width=16) (actual time=5.384..5.384 rows=0 loops=1)

2. 0.000 5.383 ↓ 0.0 0 1

Nested Loop (cost=12.90..1,386.33 rows=2 width=20) (actual time=5.383..5.383 rows=0 loops=1)

3. 0.007 5.383 ↓ 0.0 0 1

Hash Join (cost=12.62..1,381.73 rows=5 width=16) (actual time=5.383..5.383 rows=0 loops=1)

  • Hash Cond: (checkpointmessages.cm_nl_entry_id = zonenodes.zn_nl_id)
4. 5.364 5.364 ↑ 828.0 1 1

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

  • Filter: ((cm_date >= 1560016870) AND (cm_date <= 1562608879))
  • Rows Removed by Filter: 64890
5. 0.001 0.012 ↓ 0.0 0 1

Hash (cost=12.59..12.59 rows=2 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using zn_unique_row on zonenodes (cost=0.28..12.59 rows=2 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (zn_z_id = ANY ('{12,13}'::integer[]))
  • Heap Fetches: 0
7. 0.000 0.000 ↓ 0.0 0

Index Scan using nodeslogical_pkey on nodeslogical (cost=0.29..0.92 rows=1 width=8) (never executed)

  • Index Cond: (nl_id = checkpointmessages.cm_nl_mobile_id)
  • Filter: (nl_isactive = 1)
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using nodesphysical_pkey on nodesphysical (cost=0.28..0.93 rows=1 width=4) (never executed)

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