explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7mot

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 0.215 ↑ 9.0 2 1

Sort (cost=8,877.00..8,877.04 rows=18 width=586) (actual time=0.214..0.215 rows=2 loops=1)

  • Sort Key: contract_definition.definition_date
  • Sort Method: quicksort Memory: 26kB
2. 0.004 0.188 ↑ 9.0 2 1

Nested Loop Left Join (cost=23.79..8,876.62 rows=18 width=586) (actual time=0.170..0.188 rows=2 loops=1)

3. 0.007 0.162 ↑ 9.0 2 1

Nested Loop (cost=23.37..8,868.43 rows=18 width=389) (actual time=0.150..0.162 rows=2 loops=1)

4. 0.024 0.079 ↑ 187.2 4 1

Bitmap Heap Scan on account_entry (cost=22.94..2,987.64 rows=749 width=365) (actual time=0.067..0.079 rows=4 loops=1)

  • Recheck Cond: (document_id = ANY ('{14047749,14045704}'::integer[]))
  • Heap Blocks: exact=2
5. 0.055 0.055 ↑ 187.2 4 1

Bitmap Index Scan on account_entry_document_id (cost=0.00..22.75 rows=749 width=0) (actual time=0.055..0.055 rows=4 loops=1)

  • Index Cond: (document_id = ANY ('{14047749,14045704}'::integer[]))
6. 0.076 0.076 ↓ 0.0 0 4

Index Scan using account_entry_contract_entry_id_key on account_entry_contract (cost=0.43..7.84 rows=1 width=24) (actual time=0.019..0.019 rows=0 loops=4)

  • Index Cond: (entry_id = account_entry.id)
7. 0.022 0.022 ↑ 1.0 1 2

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

  • Index Cond: (account_entry_contract.contract_definition_id = id)