explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6fMn

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 5.897 ↑ 1.0 1 1

Limit (cost=2.14..205.84 rows=1 width=4,881) (actual time=5.897..5.897 rows=1 loops=1)

2. 0.524 5.896 ↑ 76,595.0 1 1

Nested Loop Left Join (cost=2.14..15,602,704.75 rows=76,595 width=4,881) (actual time=5.896..5.896 rows=1 loops=1)

  • Join Filter: ((w.warrant_disposition = sys.code) AND (sys.code_name = 'Warrant Disposition'::text))
  • Rows Removed by Join Filter: 5732
3. 0.518 3.250 ↑ 76,595.0 1 1

Nested Loop Left Join (cost=2.14..7,919,197.65 rows=76,595 width=4,732) (actual time=3.250..3.250 rows=1 loops=1)

  • Join Filter: ((w.warrant_type = sys.code) AND (sys.code_name = 'Warrant Type'::text))
  • Rows Removed by Join Filter: 5732
4. 0.003 0.112 ↑ 76,595.0 1 1

Nested Loop Left Join (cost=2.14..235,690.55 rows=76,595 width=4,583) (actual time=0.112..0.112 rows=1 loops=1)

  • Join Filter: (w.how_received = sys.code)
5. 0.004 0.096 ↑ 76,595.0 1 1

Nested Loop Left Join (cost=1.86..231,089.83 rows=76,595 width=4,434) (actual time=0.096..0.096 rows=1 loops=1)

6. 0.001 0.083 ↑ 76,595.0 1 1

Nested Loop Left Join (cost=1.43..183,038.53 rows=76,595 width=4,271) (actual time=0.083..0.083 rows=1 loops=1)

7. 0.003 0.073 ↑ 76,595.0 1 1

Nested Loop Left Join (cost=1.01..137,470.80 rows=76,595 width=3,560) (actual time=0.073..0.073 rows=1 loops=1)

8. 0.003 0.062 ↑ 76,595.0 1 1

Nested Loop Left Join (cost=0.58..82,819.24 rows=76,595 width=3,401) (actual time=0.062..0.062 rows=1 loops=1)

9. 0.004 0.050 ↑ 76,595.0 1 1

Nested Loop Left Join (cost=0.29..48,121.35 rows=76,595 width=1,917) (actual time=0.050..0.050 rows=1 loops=1)

10. 0.028 0.028 ↑ 76,595.0 1 1

Seq Scan on warrant w (cost=0.00..19,895.95 rows=76,595 width=956) (actual time=0.028..0.028 rows=1 loops=1)

11. 0.018 0.018 ↑ 1.0 1 1

Index Scan using warrant_charge_idx_wlink on warrant_charge wc (cost=0.29..0.36 rows=1 width=961) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (w.warrant_link = warrant_link)
12. 0.009 0.009 ↑ 1.0 1 1

Index Scan using warrant_name_idx_wlink on warrant_name wm (cost=0.29..0.44 rows=1 width=1,484) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (w.warrant_link = warrant_link)
  • Filter: (involvement_type = 'Subject'::text)
13. 0.008 0.008 ↑ 1.0 1 1

Index Scan using idx_pt_people_names_convertedid_wtrun on pt_people_names p (cost=0.42..0.70 rows=1 width=159) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ((wm.warrant_name_zid = convertedid) AND (wtrun = 479))
14. 0.009 0.009 ↑ 1.0 1 1

Index Scan using master_address_idx_link on master_address ma (cost=0.42..0.58 rows=1 width=711) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (master_address_link = wm.master_address_link)
15. 0.009 0.009 ↑ 1.0 1 1

Index Scan using pt_addresses_convertedid_wtrun_idx on pt_addresses pa (cost=0.43..0.62 rows=1 width=163) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((ma.master_address_zid = convertedid) AND (wtrun = 100))
16. 0.001 0.013 ↑ 4.0 1 1

Materialize (cost=0.28..5.03 rows=4 width=149) (actual time=0.013..0.013 rows=1 loops=1)

17. 0.012 0.012 ↑ 4.0 1 1

Index Scan using sys_system_code_idx_code_codename on sys_system_code sys (cost=0.28..5.01 rows=4 width=149) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (code_name = 'Warrant How Received'::text)
18. 2.007 2.620 ↑ 1.0 5,732 1

Materialize (cost=0.00..276.98 rows=5,732 width=149) (actual time=0.044..2.620 rows=5,732 loops=1)

19. 0.613 0.613 ↑ 1.0 5,732 1

Seq Scan on sys_system_code sys_wt (cost=0.00..248.32 rows=5,732 width=149) (actual time=0.043..0.613 rows=5,732 loops=1)

20. 1.600 2.122 ↑ 1.0 5,732 1

Materialize (cost=0.00..276.98 rows=5,732 width=149) (actual time=0.031..2.122 rows=5,732 loops=1)

21. 0.522 0.522 ↑ 1.0 5,732 1

Seq Scan on sys_system_code sys_wd (cost=0.00..248.32 rows=5,732 width=149) (actual time=0.029..0.522 rows=5,732 loops=1)

Planning time : 6.737 ms
Execution time : 6.818 ms