explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8sow

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

Limit (cost=0.00..144,040.94 rows=1,000 width=40) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..380,414,997.22 rows=2,641,020 width=40) (actual rows= loops=)

  • Join Filter: ((_daily_record._date >= _user_dynamic._valid_from) AND (_daily_record._date < COALESCE(_user_dynamic._valid_to, '9999-01-01 00:00:00'::timestamp without time zone)) AND (_daily_record._user = _user_dynamic._user))
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..54,407,282.27 rows=2,641,020 width=36) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..47,329,187.46 rows=2,641,020 width=36) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..32,534,449.77 rows=2,641,020 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..16,896,130.22 rows=2,641,020 width=28) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan Backward using _time_record_pkey on _time_record (cost=0.00..320,893.27 rows=2,641,020 width=20) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using _daily_record_pkey on _daily_record (cost=0.00..6.27 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (_time_record._daily_record = id)
9. 0.000 0.000 ↓ 0.0

Index Scan using _time_wp_pkey on _time_wp (cost=0.00..5.91 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (_time_record._wp = id)
10. 0.000 0.000 ↓ 0.0

Index Scan using _time_project_pkey on _time_project (cost=0.00..5.59 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (_time_wp._project = id)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using _cost_center_pkey on _cost_center (cost=0.00..2.67 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = _time_project._cost_center)
12. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..221.58 rows=6,172 width=24) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on _user_dynamic (cost=0.00..190.72 rows=6,172 width=24) (actual rows= loops=)