explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CqYK

Settings
# exclusive inclusive rows x rows loops node
1. 62.847 87.924 ↑ 257.5 406 1

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

  • Join Filter: (SubPlan 2)
  • Rows Removed by Join Filter: 9105
2. 1.400 4.953 ↑ 22.0 36 1

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

  • Join Filter: (SubPlan 1)
  • Rows Removed by Join Filter: 1548
3. 0.023 0.037 ↑ 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.020..0.037 rows=6 loops=1)

  • Recheck Cond: (client_id = 1005)
  • Heap Blocks: exact=4
4. 0.014 0.014 ↑ 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.014..0.014 rows=6 loops=1)

  • Index Cond: (client_id = 1005)
5. 0.221 0.348 ↑ 1.0 264 6

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

6. 0.127 0.127 ↑ 1.0 264 1

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

7.          

SubPlan (for Nested Loop Left Join)

8. 3.168 3.168 ↑ 16.7 6 1,584

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

9. 1.018 1.116 ↑ 1.0 264 36

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

10. 0.098 0.098 ↑ 1.0 264 1

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

11.          

SubPlan (for Nested Loop Left Join)

12. 19.008 19.008 ↑ 9.1 11 9,504

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

Planning time : 0.244 ms
Execution time : 88.038 ms