explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Za14

Settings
# exclusive inclusive rows x rows loops node
1. 0.267 3.006 ↑ 5.8 156 1

Sort (cost=171,228.76..171,231.03 rows=909 width=586) (actual time=2.988..3.006 rows=156 loops=1)

  • Sort Key: contract_definition.definition_date
  • Sort Method: quicksort Memory: 105kB
2. 0.092 2.739 ↑ 5.8 156 1

Nested Loop Left Join (cost=1.41..171,184.09 rows=909 width=586) (actual time=0.048..2.739 rows=156 loops=1)

3. 0.151 2.335 ↑ 5.8 156 1

Nested Loop (cost=0.99..170,770.61 rows=909 width=389) (actual time=0.039..2.335 rows=156 loops=1)

4. 0.349 1.384 ↑ 95.4 400 1

Nested Loop (cost=0.56..153,377.86 rows=38,153 width=365) (actual time=0.028..1.384 rows=400 loops=1)

5. 0.035 0.035 ↓ 2.0 200 1

Result (cost=0.00..0.51 rows=100 width=4) (actual time=0.007..0.035 rows=200 loops=1)

6. 1.000 1.000 ↑ 191.0 2 200

Index Scan using account_entry_document_id on account_entry (cost=0.56..1,529.94 rows=382 width=365) (actual time=0.004..0.005 rows=2 loops=200)

  • Index Cond: (document_id = (unnest('{14047749,14045704,21141006,14045713,14046227,14046744,14045722,14046237,14046238,14045727,19793955,14045732,14046243,14046247,14045737,14046250,14047788,14047280,14045747,14046772,14046260,1404 (...)
7. 0.800 0.800 ↓ 0.0 0 400

Index Scan using account_entry_contract_entry_id_key on account_entry_contract (cost=0.43..0.45 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=400)

  • Index Cond: (entry_id = account_entry.id)
8. 0.312 0.312 ↑ 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.002..0.002 rows=1 loops=156)

  • Index Cond: (account_entry_contract.contract_definition_id = id)