explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AXds

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 11.419 ↓ 0.0 0 1

Sort (cost=156.08..156.09 rows=1 width=40) (actual time=11.419..11.419 rows=0 loops=1)

  • Sort Key: entry.id
  • Sort Method: quicksort Memory: 25kB
2. 0.001 11.394 ↓ 0.0 0 1

Nested Loop (cost=152.15..156.07 rows=1 width=40) (actual time=11.394..11.394 rows=0 loops=1)

3. 0.000 11.393 ↓ 0.0 0 1

Nested Loop (cost=152.02..155.36 rows=1 width=40) (actual time=11.393..11.393 rows=0 loops=1)

4. 0.002 11.393 ↓ 0.0 0 1

Bitmap Heap Scan on alf_prop_link sp_pl (cost=151.59..152.70 rows=1 width=8) (actual time=11.393..11.393 rows=0 loops=1)

  • Recheck Cond: ((value_prop_id = 3279728) AND (key_prop_id = 41))
5. 0.001 11.391 ↓ 0.0 0 1

BitmapAnd (cost=151.59..151.59 rows=1 width=0) (actual time=11.391..11.391 rows=0 loops=1)

6. 11.390 11.390 ↓ 0.0 0 1

Bitmap Index Scan on fk_alf_propln_val (cost=0.00..2.79 rows=168 width=0) (actual time=11.390..11.390 rows=0 loops=1)

  • Index Cond: (value_prop_id = 3279728)
7. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_alf_propln_key (cost=0.00..148.55 rows=13,735 width=0) (never executed)

  • Index Cond: (key_prop_id = 41)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_alf_aud_ent_pro on alf_audit_entry entry (cost=0.43..2.65 rows=1 width=40) (never executed)

  • Index Cond: (audit_values_id = sp_pl.root_prop_id)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using alf_audit_app_pkey on alf_audit_app app (cost=0.13..0.70 rows=1 width=16) (never executed)

  • Index Cond: (id = entry.audit_app_id)
  • Filter: (app_name_id = 5)