explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 76G

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 81.202 ↓ 0.0 0 1

Sort (cost=62,383.85..62,385.81 rows=787 width=595) (actual time=81.202..81.202 rows=0 loops=1)

  • Sort Key: contract_definition.definition_date
  • Sort Method: quicksort Memory: 25kB
2. 7.510 82.881 ↓ 0.0 0 1

Gather (cost=42,720.35..62,345.99 rows=787 width=595) (actual time=81.198..82.881 rows=0 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 0.001 75.371 ↓ 0.0 0 4

Nested Loop Left Join (cost=41,720.35..61,267.29 rows=254 width=595) (actual time=75.371..75.371 rows=0 loops=4)

4. 38.300 75.370 ↓ 0.0 0 4

Hash Join (cost=41,719.93..60,843.38 rows=254 width=392) (actual time=75.370..75.370 rows=0 loops=4)

  • Hash Cond: (account_entry_contract.entry_id = account_entry.id)
5. 35.000 35.000 ↑ 1.3 419,865 4

Parallel Seq Scan on account_entry_contract (cost=0.00..17,042.21 rows=554,321 width=28) (actual time=0.005..35.000 rows=419,865 loops=4)

6. 0.286 2.070 ↑ 69.4 387 4

Hash (cost=41,384.09..41,384.09 rows=26,867 width=364) (actual time=2.070..2.070 rows=387 loops=4)

  • Buckets: 32768 Batches: 1 Memory Usage: 357kB
7. 1.784 1.784 ↑ 69.4 387 4

Index Scan using account_entry_document_id on account_entry (cost=0.56..41,384.09 rows=26,867 width=364) (actual time=0.020..1.784 rows=387 loops=4)

  • Index Cond: (document_id = ANY ('{22276610,22362116,22552585,22277645,22554644,22329366,22260248,22336543,22285856,22348325,22348839,22349355,22490159,22260785,22320183,22335548,22340156,22550588,22276674,22550082,22488645,2 (...)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using contract_definition_pkey on contract_definition (cost=0.42..1.66 rows=1 width=203) (never executed)

  • Index Cond: (account_entry_contract.contract_definition_id = id)