explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 939X

Settings
# exclusive inclusive rows x rows loops node
1. 43.492 44.596 ↑ 1.4 406 1

Nested Loop Left Join (cost=4.62..682.03 rows=580 width=193) (actual time=0.178..44.596 rows=406 loops=1)

2. 0.077 0.204 ↑ 1.6 36 1

Nested Loop Left Join (cost=4.47..52.78 rows=59 width=144) (actual time=0.037..0.204 rows=36 loops=1)

3. 0.021 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.023..0.037 rows=6 loops=1)

  • Recheck Cond: (client_id = 1,005)
  • Heap Blocks: exact=4
4. 0.016 0.016 ↑ 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.016..0.016 rows=6 loops=1)

  • Index Cond: (client_id = 1,005)
5. 0.090 0.090 ↑ 1.7 6 6

Index Scan using pk_entity_type on entity_type pet (cost=0.15..5.65 rows=10 width=23) (actual time=0.003..0.015 rows=6 loops=6)

  • Index Cond: (id = ANY (dtfp.parent_document_type_id))
6. 0.900 0.900 ↓ 1.1 11 36

Index Scan using pk_entity_type on entity_type et2 (cost=0.15..5.65 rows=10 width=23) (actual time=0.002..0.025 rows=11 loops=36)

  • Index Cond: (id = ANY (dtfp.secondary_entity_type_id))
Planning time : 0.263 ms
Execution time : 44.711 ms