explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Im4Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.814 17,714.029 ↓ 1.2 92 1

HashAggregate (cost=150,736,630.60..150,736,631.58 rows=78 width=8) (actual time=17,713.994..17,714.029 rows=92 loops=1)

  • Group Key: p.publisher_id
  • Execution time: 17,714.123 ms(19 Zeilen)
2. 0.143 0.143 ↓ 1.1 104 1

Seq Scan on projects p (cost=0.00..2.91 rows=91 width=8) (actual time=0.009..0.143 rows=104 loops=1)

3.          

SubPlan (for HashAggregate)

4. 1,726.608 17,713.072 ↑ 1.0 1 104

Aggregate (cost=1,656,446.44..1,656,446.45 rows=1 width=24) (actual time=170.318..170.318 rows=1 loops=104)

5. 2,510.248 15,986.464 ↑ 2.6 17,152 104

Bitmap Heap Scan on orders (cost=40,705.99..161,037.08 rows=45,124 width=24) (actual time=130.624..153.716 rows=17,152 loops=104)

  • Recheck Cond: ((project_id = p.id) AND (status = 1))
  • Heap Blocks: exact=375,938
6. 335.243 13,476.216 ↓ 0.0 0 104

BitmapAnd (cost=40,705.99..40,705.99 rows=45,124 width=0) (actual time=129.579..129.579 rows=0 loops=104)

7. 448.552 448.552 ↑ 2.6 39,444 104

Bitmap Index Scan on orders_project_id_idx (cost=0.00..1,897.59 rows=102,554 width=0) (actual time=4.313..4.313 rows=39,444 loops=104)

  • Index Cond: (project_id = p.id)
8. 12,692.421 12,692.421 ↓ 1.2 2,190,987 63

Bitmap Index Scan on orders_status_idx (cost=0.00..38,785.59 rows=1,804,955 width=0) (actual time=201.467..201.467 rows=2,190,987 loops=63)

  • Index Cond: (status = 1)
9.          

SubPlan (for Aggregate)

10. 0.000 0.000 ↓ 0.0 0

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

11. 0.000 0.000 ↓ 0.0 0

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

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