explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b0Kv

Settings

Optimization(s) for this plan:

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

CTE Scan on ste_symbol sr (cost=4,602.20..4,602.22 rows=1 width=635) (actual rows= loops=)

2.          

CTE ste_symbol

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=48.91..4,602.20 rows=1 width=135) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=48.77..4,602.04 rows=1 width=118) (actual rows= loops=)

  • Join Filter: (ss.sid = ls.id)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=48.77..4,596.98 rows=1 width=83) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on data ss (cost=48.48..4,588.67 rows=1 width=63) (actual rows= loops=)

  • Recheck Cond: ((dt >= '2019-02-05 00:00:00'::timestamp without time zone) AND (dt <= '2019-02-05 00:00:00'::timestamp without time zone))
  • Filter: ((contract_id = COALESCE(contract_id)) AND (sid = 2))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on data_idx19 (cost=0.00..48.48 rows=1,205 width=0) (actual rows= loops=)

  • Index Cond: ((dt >= '2019-02-05 00:00:00'::timestamp without time zone) AND (dt <= '2019-02-05 00:00:00'::timestamp without time zone))
8. 0.000 0.000 ↓ 0.0

Index Scan using contracts_contract_id_key on contracts cc (cost=0.29..8.30 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (ss.contract_id = contract_id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on symbols ls (cost=0.00..5.05 rows=1 width=39) (actual rows= loops=)

  • Filter: (id = 2)
10. 0.000 0.000 ↓ 0.0

Index Scan using basis_idx on basis cb (cost=0.14..0.16 rows=1 width=25) (actual rows= loops=)

  • Index Cond: (cc.basis_id = id)