explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fEQem : Optimization for: plan #wkr3

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=5.22..78.35 rows=2 width=16) (actual time=0.013..0.013 rows=0 loops=1)

2. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=4.94..76.49 rows=2 width=20) (actual time=0.013..0.013 rows=0 loops=1)

3. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=4.66..71.90 rows=5 width=16) (actual time=0.013..0.013 rows=0 loops=1)

4. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

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

Bitmap Heap Scan on checkpointmessages (cost=4.38..29.58 rows=7 width=12) (never executed)

  • Recheck Cond: ((cm_nl_entry_id = zonenodes.zn_nl_id) AND (cm_date >= 1560016870) AND (cm_date <= 1562608879))
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on cm_indextrackingfixed (cost=0.00..4.38 rows=7 width=0) (never executed)

  • Index Cond: ((cm_nl_entry_id = zonenodes.zn_nl_id) AND (cm_date >= 1560016870) AND (cm_date <= 1562608879))
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.772 ms