explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GMXK

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,035.325 ↑ 1.0 1 1

Result (cost=176,781.73..176,781.74 rows=1 width=1) (actual time=1,035.325..1,035.325 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.155 1,035.323 ↑ 2.0 1 1

Nested Loop (cost=4,423.51..349,139.95 rows=2 width=0) (actual time=1,035.323..1,035.323 rows=1 loops=1)

4. 892.253 1,035.092 ↑ 2.0 1 1

Bitmap Heap Scan on billing_document_attrs (cost=4,422.95..349,135.01 rows=2 width=4) (actual time=1,035.092..1,035.092 rows=1 loops=1)

  • Recheck Cond: ((name)::text = 'crit_unique_ref_id'::text)
  • Filter: (((type)::text = 'str'::text) AND ((value_str)::text = 'UA-1472448-59-1569841948'::text))
  • Rows Removed by Filter: 495,375
  • Heap Blocks: exact=287,342
5. 142.839 142.839 ↓ 1.7 495,376 1

Bitmap Index Scan on ix_billing_document_attrs_name_value_long (cost=0.00..4,422.94 rows=290,966 width=0) (actual time=142.839..142.839 rows=495,376 loops=1)

  • Index Cond: ((name)::text = 'crit_unique_ref_id'::text)
6. 0.076 0.076 ↑ 1.0 1 1

Index Only Scan using billing_document_pkey on billing_document (cost=0.57..2.46 rows=1 width=4) (actual time=0.076..0.076 rows=1 loops=1)

  • Index Cond: (id = billing_document_attrs.owner_id)
  • Heap Fetches: 1
Planning time : 2.509 ms
Execution time : 1,037.754 ms