explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oHhT

Settings
# exclusive inclusive rows x rows loops node
1. 35.632 48.267 ↑ 257.5 406 1

Nested Loop Left Join (cost=4.32..135,256.98 rows=104,544 width=193) (actual time=0.459..48.267 rows=406 loops=1)

  • Join Filter: (SubPlan 2)
  • Rows Removed by Join Filter: 9,105
2. 0.708 2.555 ↑ 22.0 36 1

Nested Loop Left Join (cost=4.32..649.28 rows=792 width=144) (actual time=0.133..2.555 rows=36 loops=1)

  • Join Filter: (SubPlan 1)
  • Rows Removed by Join Filter: 1,548
3. 0.020 0.035 ↑ 1.0 6 1

Bitmap Heap Scan on document_type_feature_provisioning dtfp (cost=4.32..18.28 rows=6 width=121) (actual time=0.019..0.035 rows=6 loops=1)

  • Recheck Cond: (client_id = 1,005)
  • Heap Blocks: exact=4
4. 0.015 0.015 ↑ 1.0 6 1

Bitmap Index Scan on uk_document_type_feature_provisioning_2 (cost=0.00..4.32 rows=6 width=0) (actual time=0.015..0.015 rows=6 loops=1)

  • Index Cond: (client_id = 1,005)
5. 0.147 0.228 ↑ 1.0 264 6

Materialize (cost=0.00..7.96 rows=264 width=23) (actual time=0.002..0.038 rows=264 loops=6)

6. 0.081 0.081 ↑ 1.0 264 1

Seq Scan on entity_type pet (cost=0.00..6.64 rows=264 width=23) (actual time=0.010..0.081 rows=264 loops=1)

7.          

SubPlan (for Nested Loop Left Join)

8. 1.584 1.584 ↑ 16.7 6 1,584

Result (cost=0.00..0.51 rows=100 width=4) (actual time=0.000..0.001 rows=6 loops=1,584)

9. 0.513 0.576 ↑ 1.0 264 36

Materialize (cost=0.00..7.96 rows=264 width=23) (actual time=0.000..0.016 rows=264 loops=36)

10. 0.063 0.063 ↑ 1.0 264 1

Seq Scan on entity_type et2 (cost=0.00..6.64 rows=264 width=23) (actual time=0.003..0.063 rows=264 loops=1)

11.          

SubPlan (for Nested Loop Left Join)

12. 9.504 9.504 ↑ 9.1 11 9,504

Result (cost=0.00..0.51 rows=100 width=4) (actual time=0.000..0.001 rows=11 loops=9,504)

Planning time : 0.136 ms
Execution time : 48.360 ms