explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KORJ

Settings
# exclusive inclusive rows x rows loops node
1. 137.659 220.148 ↓ 0.0 0 1

Insert on core_aggregateentry (cost=3,754.69..3,793.30 rows=1,287 width=43) (actual time=220.148..220.148 rows=0 loops=1)

2. 15.831 82.489 ↓ 9.9 12,772 1

Subquery Scan on *SELECT* (cost=3,754.69..3,793.30 rows=1,287 width=43) (actual time=55.766..82.489 rows=12,772 loops=1)

3. 19.479 66.658 ↓ 9.9 12,772 1

HashAggregate (cost=3,754.69..3,770.78 rows=1,287 width=43) (actual time=55.754..66.658 rows=12,772 loops=1)

  • Group Key: core_entry_1.company_id, core_entry_1.date, core_entry_1.entry_type
4. 1.177 47.179 ↑ 1.0 12,772 1

Append (cost=0.00..3,625.98 rows=12,871 width=22) (actual time=3.377..47.179 rows=12,772 loops=1)

5. 46.002 46.002 ↑ 1.0 12,772 1

Seq Scan on core_entry_1 (cost=0.00..3,561.62 rows=12,871 width=22) (actual time=3.376..46.002 rows=12,772 loops=1)

  • Filter: ((company_id = 1) AND ((entry_type)::text = ANY ('{1t,1g,pm,pp,fa,in,cp,mr,li,op,rv,po,te,vp,mg}'::text[])))
  • Rows Removed by Filter: 74256
Planning time : 0.695 ms
Execution time : 220.581 ms