explain.depesz.com

PostgreSQL's explain analyze made readable

Result: td5H

Settings
# exclusive inclusive rows x rows loops node
1. 117.986 278.271 ↓ 1.2 27,899 1

HashAggregate (cost=73,620.31..74,515.59 rows=22,382 width=149) (actual time=245.703..278.271 rows=27,899 loops=1)

  • Group Key: gd.cid, gd.property_id, gd.accrual_gl_account_id, gd.period_id, gh.gl_book_id, (COALESCE(gd.property_building_id, 0)), (COALESCE(gd.property_unit_id, 0)), (COALESCE(gd.gl_dimension_id, 0)), (COALESCE(gd.company_department_id, 0)), gd.post_month, gh.post_date, ((gh.gl_header_status_type_id = 2))
2. 0.000 160.285 ↓ 3.6 80,723 1

Gather (cost=1,001.00..72,669.08 rows=22,382 width=50) (actual time=1.515..160.285 rows=80,723 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.000 192.376 ↓ 2.9 26,908 3 / 3

Nested Loop (cost=1.00..69,398.24 rows=9,326 width=50) (actual time=0.827..192.376 rows=26,908 loops=3)

4. 112.373 112.373 ↓ 1.6 26,908 3 / 3

Parallel Index Scan using idx_gl_details_cid_property_id_post_month_accrual_gl_account_id on gl_details gd (cost=0.56..35,899.85 rows=16,533 width=45) (actual time=0.757..112.373 rows=26,908 loops=3)

  • Index Cond: ((cid = 13,576) AND (property_id = 347,830) AND (post_month > '10/01/2019'::date) AND (accrual_gl_account_id IS NOT NULL))
5. 80.723 80.723 ↑ 1.0 1 80,723 / 3

Index Scan using idx_gl_headers_id on gl_headers gh (cost=0.43..2.02 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=80,723)

  • Index Cond: (id = gd.gl_header_id)
  • Filter: ((is_template IS FALSE) AND (cid = 13,576) AND (gl_header_status_type_id = ANY ('{1,2,3}'::integer[])))
Planning time : 2.152 ms
Execution time : 280.709 ms