explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QiLk

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 7,516.252 ↓ 0.0 0 1

Limit (cost=4.80..149.14 rows=1 width=5,248) (actual time=7,516.252..7,516.252 rows=0 loops=1)

2. 7,482.242 7,516.250 ↓ 0.0 0 1

Bitmap Heap Scan on addresses (cost=4.80..149.14 rows=1 width=5,248) (actual time=7,516.249..7,516.250 rows=0 loops=1)

  • Recheck Cond: (((owner_type)::text = 'Customer'::text) AND ((label)::text = 'Faktura'::text))
  • Filter: (owner_id = 55054280)
  • Rows Removed by Filter: 312925
  • Heap Blocks: exact=19714
3. 34.008 34.008 ↓ 8,457.4 312,925 1

Bitmap Index Scan on index_addresses_on_owner_type_and_label (cost=0.00..4.80 rows=37 width=0) (actual time=34.008..34.008 rows=312,925 loops=1)

  • Index Cond: (((owner_type)::text = 'Customer'::text) AND ((label)::text = 'Faktura'::text))
Planning time : 0.133 ms
Execution time : 7,516.286 ms