#	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

 Aggregate  (cost=224.70..224.71 rows=1 width=6) (actual time=10.111..10.111 rows=1 loops=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)
         ->  Nested Loop  (cost=0.70..16.76 rows=1 width=18) (actual time=2.463..3.984 rows=1 loops=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
               ->  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)
         ->  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

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.003 ms	0.0 %
Index Scan	2	3.977 ms	39.3 %
Nested Loop	2	0.011 ms	0.1 %
Seq Scan	1	6.120 ms	60.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cb_hr_conceptoutcomedetail	1	3.648 ms	36.1 %
Index Scan	1	3.648 ms	100.0 %
cb_hr_earningcodes	1	0.329 ms	3.3 %
Index Scan	1	0.329 ms	100.0 %
cb_hr_earningcodes_taxcfg	1	6.120 ms	60.5 %
Seq Scan	1	6.120 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yQPg

Color mode:

Visible columns:

Per node type stats

Per table stats