explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4hmj

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 3,627.360 ↓ 5.0 5 1

Nested Loop (cost=0.43..2,647,794.94 rows=1 width=448) (actual time=3,627.318..3,627.360 rows=5 loops=1)

2. 0.014 3,627.299 ↑ 4.3 20 1

Append (cost=0.00..2,647,059.34 rows=87 width=445) (actual time=3,627.255..3,627.299 rows=20 loops=1)

3. 0.070 0.070 ↓ 0.0 0 1

Seq Scan on work_order_line_item_history_new_y2005_2007 (cost=0.00..8.08 rows=1 width=401) (actual time=0.070..0.070 rows=0 loops=1)

  • Filter: ((work_order_id = 44224) AND ((created_date_time)::date = '2020-01-23'::date))
  • Rows Removed by Filter: 176
4. 0.003 0.003 ↓ 0.0 0 1

Index Scan using work_order_line_item_history__work_order_line_item_history_idx1 on work_order_line_item_history_new_y2008_2010 (cost=0.14..8.46 rows=1 width=1,646) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (work_order_id = 44224)
  • Filter: ((created_date_time)::date = '2020-01-23'::date)
5. 320.596 320.596 ↓ 0.0 0 1

Index Scan using work_order_line_item_history__work_order_line_item_history_idx2 on work_order_line_item_history_new_y2011_2013 (cost=0.56..244,784.80 rows=11 width=516) (actual time=320.595..320.596 rows=0 loops=1)

  • Index Cond: (work_order_id = 44224)
  • Filter: ((created_date_time)::date = '2020-01-23'::date)
6. 1,430.441 1,430.441 ↓ 0.0 0 1

Index Scan using work_order_line_item_history__work_order_line_item_history_idx3 on work_order_line_item_history_new_y2014_2016 (cost=0.56..1,061,712.39 rows=32 width=400) (actual time=1,430.441..1,430.441 rows=0 loops=1)

  • Index Cond: (work_order_id = 44224)
  • Filter: ((created_date_time)::date = '2020-01-23'::date)
7. 1,876.121 1,876.121 ↓ 0.0 0 1

Index Scan using work_order_line_item_history__work_order_line_item_history_idx4 on work_order_line_item_history_new_y2017_2019 (cost=0.56..1,340,533.51 rows=40 width=399) (actual time=1,876.121..1,876.121 rows=0 loops=1)

  • Index Cond: (work_order_id = 44224)
  • Filter: ((created_date_time)::date = '2020-01-23'::date)
8. 0.045 0.045 ↓ 20.0 20 1

Seq Scan on work_order_line_item_history_new_y2020_2022 (cost=0.00..3.23 rows=1 width=624) (actual time=0.018..0.045 rows=20 loops=1)

  • Filter: ((work_order_id = 44224) AND ((created_date_time)::date = '2020-01-23'::date))
  • Rows Removed by Filter: 50
9. 0.009 0.009 ↓ 0.0 0 1

Index Scan using work_order_line_item_history__work_order_line_item_history_idx6 on work_order_line_item_history_new_y2023_2025 (cost=0.14..8.46 rows=1 width=1,646) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (work_order_id = 44224)
  • Filter: ((created_date_time)::date = '2020-01-23'::date)
10. 0.040 0.040 ↓ 0.0 0 20

Index Only Scan using work_order_room_history_index on work_order_room_history (cost=0.43..8.45 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=20)

  • Index Cond: ((work_order_room_history_id = work_order_line_item_history_new_y2005_2007.work_order_room_history_id) AND (work_order_history_id = 685061))
  • Heap Fetches: 5