explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VZ6C

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 18.373 ↑ 1.0 1 1

Aggregate (cost=11,199.43..11,199.44 rows=1 width=6) (actual time=18.373..18.373 rows=1 loops=1)

2. 0.001 18.370 ↓ 0.0 0 1

Nested Loop (cost=0.42..11,199.42 rows=1 width=6) (actual time=18.370..18.370 rows=0 loops=1)

  • Join Filter: (con.record_id = ed.cb_hr_earningcodes_id)
3. 0.005 18.369 ↓ 0.0 0 1

Nested Loop (cost=0.42..11,082.38 rows=1 width=19) (actual time=18.369..18.369 rows=0 loops=1)

  • Join Filter: (con.record_id = td.cb_hr_earningcodes_id)
4. 1.944 1.944 ↑ 1.0 1 1

Index Scan using conceptoutcomedetail_idx on cb_hr_conceptoutcomedetail con (cost=0.42..8.45 rows=1 width=12) (actual time=1.920..1.944 rows=1 loops=1)

  • Index Cond: ((c_bpartner_id = 1387499::numeric) AND (cb_hr_payroll_id = 1000061::numeric) AND (cb_hr_period_id = 1003075::numeric) AND (cb_hr_process_id = 1001592::numeric))
  • Filter: ((isprinted = 'Y'::bpchar) AND ((keytype)::text = 'Earnings'::text))
  • Rows Removed by Filter: 12
5. 16.420 16.420 ↓ 0.0 0 1

Seq Scan on cb_hr_earningcodes_taxcfg td (cost=0.00..11,073.92 rows=1 width=7) (actual time=16.420..16.420 rows=0 loops=1)

  • Filter: ((isactive = 'Y'::bpchar) AND (istaxable = 'N'::bpchar) AND (cb_hr_taxes_id = 1000362::numeric))
  • Rows Removed by Filter: 5824
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on cb_hr_earningcodes ed (cost=0.00..95.54 rows=1,720 width=6) (never executed)

  • Filter: (isactive = 'Y'::bpchar)
Planning time : 3.259 ms
Execution time : 18.492 ms