explain.depesz.com

PostgreSQL's explain analyze made readable

Result: moCC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,785.615 ↑ 894.1 953 1

Finalize HashAggregate (cost=969,334.03..994,896.49 rows=852,082 width=50) (actual time=2,779.827..2,785.615 rows=953 loops=1)

  • Group Key: field, external_field_name
2. 298.726 3,058.188 ↑ 611.2 2,788 1

Gather (cost=764,834.35..960,813.21 rows=1,704,164 width=50) (actual time=2,769.437..3,058.188 rows=2,788 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 917.591 2,759.462 ↑ 917.2 929 3 / 3

Partial HashAggregate (cost=763,834.35..789,396.81 rows=852,082 width=50) (actual time=2,753.393..2,759.462 rows=929 loops=3)

  • Group Key: field, external_field_name
4. 1,841.871 1,841.871 ↑ 1.3 3,637,772 3 / 3

Parallel Index Scan using idx_document_merge_fields_cid_document_id_document_addenda_id on document_merge_fields dmf (cost=0.56..740,766.94 rows=4,613,482 width=50) (actual time=0.036..1,841.871 rows=3,637,772 loops=3)

  • Index Cond: ((cid = 1,826) AND (document_id = ANY ('{196536,196526,196553,196587,196591,196623,196642,196658,196710,196712,196725,196736,196740,196762,196777}'::integer[])))
Planning time : 0.766 ms
Execution time : 3,100.654 ms