explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yQPg

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

Aggregate (cost=224.70..224.71 rows=1 width=6) (actual time=10.111..10.111 rows=1 loops=1)

2. 0.004 10.108 ↓ 0.0 0 1

Nested Loop (cost=0.70..224.69 rows=1 width=6) (actual time=10.108..10.108 rows=0 loops=1)

  • Join Filter: (ed.cb_hr_earningcodes_id = td.cb_hr_earningcodes_id)
3. 0.007 3.984 ↑ 1.0 1 1

Nested Loop (cost=0.70..16.76 rows=1 width=18) (actual time=2.463..3.984 rows=1 loops=1)

4. 3.648 3.648 ↑ 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=2.130..3.648 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. 0.329 0.329 ↑ 1.0 1 1

Index Scan using cb_hr_earningcodes_pkey on cb_hr_earningcodes ed (cost=0.28..8.30 rows=1 width=6) (actual time=0.328..0.329 rows=1 loops=1)

  • Index Cond: (cb_hr_earningcodes_id = con.record_id)
  • Filter: (isactive = 'Y'::bpchar)
6. 6.120 6.120 ↓ 0.0 0 1

Seq Scan on cb_hr_earningcodes_taxcfg td (cost=0.00..207.92 rows=1 width=7) (actual time=6.120..6.120 rows=0 loops=1)

  • Filter: ((isactive = 'Y'::bpchar) AND (istaxable = 'N'::bpchar) AND (cb_hr_taxes_id = 1000362::numeric))
  • Rows Removed by Filter: 5824
Planning time : 6.096 ms
Execution time : 10.225 ms