explain.depesz.com

PostgreSQL's explain analyze made readable

Result: juX9

Settings
# exclusive inclusive rows x rows loops node
1. 0.555 254.806 ↑ 11.4 156 1

Sort (cost=302,274.95..302,279.41 rows=1,784 width=586) (actual time=254.771..254.806 rows=156 loops=1)

  • Sort Key: contract_definition.definition_date
  • Sort Method: quicksort Memory: 105kB
2. 0.387 254.251 ↑ 11.4 156 1

Nested Loop Left Join (cost=277,797.50..302,178.61 rows=1,784 width=586) (actual time=20.112..254.251 rows=156 loops=1)

3. 140.925 253.240 ↑ 11.4 156 1

Hash Join (cost=277,797.08..301,367.11 rows=1,784 width=389) (actual time=20.087..253.240 rows=156 loops=1)

  • Hash Cond: (account_entry_contract.entry_id = account_entry.id)
4. 110.737 110.737 ↑ 1.0 1,170,705 1

Seq Scan on account_entry_contract (cost=0.00..19,162.05 rows=1,170,705 width=24) (actual time=0.008..110.737 rows=1,170,705 loops=1)

5. 0.251 1.578 ↑ 187.3 400 1

Hash (cost=276,860.79..276,860.79 rows=74,903 width=365) (actual time=1.578..1.578 rows=400 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 1134kB
6. 0.753 1.327 ↑ 187.3 400 1

Bitmap Heap Scan on account_entry (cost=2,294.23..276,860.79 rows=74,903 width=365) (actual time=0.599..1.327 rows=400 loops=1)

  • Recheck Cond: (document_id = ANY ('{14047749,14045704,21141006,14045713,14046227,14046744,14045722,14046237,14046238,14045727,19793955,14045732,14046243,14046247,14045737,14046250,14047788,14047280,14045747,14046772,14046260,14046 (...)
  • Heap Blocks: exact=195
7. 0.574 0.574 ↑ 187.3 400 1

Bitmap Index Scan on account_entry_document_id (cost=0.00..2,275.50 rows=74,903 width=0) (actual time=0.574..0.574 rows=400 loops=1)

  • Index Cond: (document_id = ANY ('{14047749,14045704,21141006,14045713,14046227,14046744,14045722,14046237,14046238,14045727,19793955,14045732,14046243,14046247,14045737,14046250,14047788,14047280,14045747,14046772,14046260,1 (...)
8. 0.624 0.624 ↑ 1.0 1 156

Index Scan using contract_definition_pkey on contract_definition (cost=0.42..0.44 rows=1 width=197) (actual time=0.004..0.004 rows=1 loops=156)

  • Index Cond: (account_entry_contract.contract_definition_id = id)