explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AhQ6

Settings
# exclusive inclusive rows x rows loops node
1. 33.944 123,431.732 ↓ 1.8 47 1

HashAggregate (cost=46,614,903.57..46,614,903.89 rows=26 width=8) (actual time=123,431.666..123,431.732 rows=47 loops=1)

  • Group Key: p.publisher_id
  • Execution time: 123434.480 ms(19 Zeilen)
2. 8.004 8.004 ↑ 1.0 3,099 1

Seq Scan on projects p (cost=0.00..89.07 rows=3,107 width=8) (actual time=0.014..8.004 rows=3,099 loops=1)

3.          

SubPlan (for HashAggregate)

4. 2,070.132 123,389.784 ↑ 1.0 1 3,099

Aggregate (cost=15,003.14..15,003.15 rows=1 width=24) (actual time=39.815..39.816 rows=1 loops=3,099)

5. 3,650.622 121,319.652 ↑ 10.3 110 3,099

Bitmap Heap Scan on orders (cost=9,210.81..13,390.07 rows=1,130 width=24) (actual time=37.985..39.148 rows=110 loops=3,099)

  • Recheck Cond: ((project_id = p.id) AND (status = 1))
  • Heap Blocks: exact=90319
6. 265.173 117,669.030 ↓ 0.0 0 3,099

BitmapAnd (cost=9,210.81..9,210.81 rows=1,130 width=0) (actual time=37.970..37.970 rows=0 loops=3,099)

7. 449.355 449.355 ↑ 10.2 588 3,099

Bitmap Index Scan on orders_project_id_idx (cost=0.00..197.43 rows=6,000 width=0) (actual time=0.145..0.145 rows=588 loops=3,099)

  • Index Cond: (project_id = p.id)
8. 116,954.502 116,954.502 ↓ 1.5 525,730 1,011

Bitmap Index Scan on orders_status_salary_id_idx (cost=0.00..9,012.57 rows=344,552 width=0) (actual time=115.682..115.682 rows=525,730 loops=1,011)

  • Index Cond: (status = 1)
9.          

SubPlan (for Aggregate)

10. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
Planning time : 0.810 ms