explain.depesz.com

PostgreSQL's explain analyze made readable

Result: STjk

Settings
# exclusive inclusive rows x rows loops node
1. 2.506 103.323 ↓ 63.0 63 1

Nested Loop (cost=1,312.89..2,059.55 rows=1 width=42) (actual time=26.515..103.323 rows=63 loops=1)

2. 3.134 27.575 ↓ 2,817.0 2,817 1

Hash Right Join (cost=1,312.60..2,058.48 rows=1 width=26) (actual time=25.990..27.575 rows=2,817 loops=1)

  • Hash Cond: (ct2.customers_id = c.customers_id)
  • Filter: ((ct2.kk_customer_tag_id IS NULL) OR (ct3.kk_customer_tag_id IS NULL))
  • Rows Removed by Filter: 2,511
3. 2.164 2.922 ↓ 1.0 2,511 1

Bitmap Heap Scan on kk_customers_to_tag ct2 (cost=87.36..804.91 rows=2,444 width=8) (actual time=0.881..2.922 rows=2,511 loops=1)

  • Recheck Cond: ((name)::text = 'NEXTBIKE_ID'::text)
  • Heap Blocks: exact=556
4. 0.758 0.758 ↓ 1.0 2,511 1

Bitmap Index Scan on idx_name_kk_customers_to_tag (cost=0.00..86.75 rows=2,444 width=0) (actual time=0.758..0.758 rows=2,511 loops=1)

  • Index Cond: ((name)::text = 'NEXTBIKE_ID'::text)
5. 2.448 21.519 ↑ 1.0 5,328 1

Hash (cost=1,157.04..1,157.04 rows=5,456 width=30) (actual time=21.519..21.519 rows=5,328 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 383kB
6. 3.285 19.071 ↑ 1.0 5,328 1

Hash Right Join (cost=432.44..1,157.04 rows=5,456 width=30) (actual time=8.216..19.071 rows=5,328 loops=1)

  • Hash Cond: (ct3.customers_id = c.customers_id)
7. 7.766 8.958 ↓ 1.0 2,511 1

Bitmap Heap Scan on kk_customers_to_tag ct3 (cost=87.68..805.76 rows=2,486 width=8) (actual time=1.330..8.958 rows=2,511 loops=1)

  • Recheck Cond: ((name)::text = 'NEXTBIKE_LOGINKEY'::text)
  • Heap Blocks: exact=550
8. 1.192 1.192 ↓ 1.0 2,511 1

Bitmap Index Scan on idx_name_kk_customers_to_tag (cost=0.00..87.06 rows=2,486 width=0) (actual time=1.192..1.192 rows=2,511 loops=1)

  • Index Cond: ((name)::text = 'NEXTBIKE_LOGINKEY'::text)
9. 2.082 6.828 ↑ 1.0 5,328 1

Hash (cost=276.56..276.56 rows=5,456 width=26) (actual time=6.827..6.828 rows=5,328 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 369kB
10. 4.746 4.746 ↑ 1.0 5,328 1

Seq Scan on customers c (cost=0.00..276.56 rows=5,456 width=26) (actual time=0.013..4.746 rows=5,328 loops=1)

11. 73.242 73.242 ↓ 0.0 0 2,817

Index Scan using idxkk_customers_to_tag_customers_id on kk_customers_to_tag ct1 (cost=0.29..1.06 rows=1 width=20) (actual time=0.026..0.026 rows=0 loops=2,817)

  • Index Cond: (customers_id = c.customers_id)
  • Filter: ((name)::text = 'PATRIS_KUNDEN_VERTRAGSNUMMER_LEIPZIGMOVE'::text)
  • Rows Removed by Filter: 5
Planning time : 4.164 ms
Execution time : 103.538 ms