explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xI7W

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 8.465 ↓ 5.0 5 1

Nested Loop Left Join (cost=1.28..18.62 rows=1 width=70) (actual time=8.436..8.465 rows=5 loops=1)

2. 0.003 8.457 ↓ 5.0 5 1

Nested Loop Left Join (cost=1.14..18.40 rows=1 width=74) (actual time=8.432..8.457 rows=5 loops=1)

3. 0.005 8.449 ↓ 5.0 5 1

Nested Loop Left Join (cost=0.99..18.17 rows=1 width=74) (actual time=8.427..8.449 rows=5 loops=1)

4. 0.006 8.434 ↓ 5.0 5 1

Nested Loop Left Join (cost=0.84..17.91 rows=1 width=74) (actual time=8.417..8.434 rows=5 loops=1)

5. 0.040 0.040 ↑ 1.0 1 1

Index Scan using identities_identity_person_id_908d4320 on identities_identity ii (cost=0.42..8.44 rows=1 width=70) (actual time=0.029..0.040 rows=1 loops=1)

  • Index Cond: (person_id = 5,850)
6. 8.388 8.388 ↓ 1.2 5 1

Index Scan using folders_folder_identity_id_e69be3c5 on folders_folder ff (cost=0.42..9.43 rows=4 width=8) (actual time=8.384..8.388 rows=5 loops=1)

  • Index Cond: (identity_id = ii.id)
7. 0.010 0.010 ↓ 0.0 0 5

Index Scan using folders_request_folder_id_demand_id_b725daea_uniq on folders_request fr (cost=0.15..0.22 rows=4 width=8) (actual time=0.002..0.002 rows=0 loops=5)

  • Index Cond: (folder_id = ff.id)
8. 0.005 0.005 ↓ 0.0 0 5

Index Only Scan using proposals_proposal_request_id_efcbcf87 on proposals_proposal pp (cost=0.14..0.21 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (request_id = fr.id)
  • Heap Fetches: 0
9. 0.000 0.000 ↓ 0.0 0 5

Index Only Scan using decisions_decision_request_id_4e771de0 on decisions_decision dd (cost=0.14..0.21 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=5)

  • Index Cond: (request_id = fr.id)
  • Heap Fetches: 0
Planning time : 1.515 ms
Execution time : 8.535 ms