explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Phj

Settings
# exclusive inclusive rows x rows loops node
1. 1.652 162.244 ↑ 10.8 63 1

Nested Loop (cost=956.46..69,477.02 rows=682 width=58) (actual time=6.472..162.244 rows=63 loops=1)

2. 7.194 16.448 ↓ 2.1 2,574 1

Hash Join (cost=956.17..1,801.12 rows=1,231 width=40) (actual time=6.361..16.448 rows=2,574 loops=1)

  • Hash Cond: (ct1.customers_id = ct2.customers_id)
3. 3.034 4.119 ↓ 1.0 3,215 1

Bitmap Heap Scan on kk_customers_to_tag ct1 (cost=112.82..839.18 rows=3,149 width=20) (actual time=1.207..4.119 rows=3,215 loops=1)

  • Recheck Cond: ((name)::text = 'PATRIS_KUNDENNUMMER'::text)
  • Heap Blocks: exact=575
4. 1.085 1.085 ↓ 1.0 3,231 1

Bitmap Index Scan on idx_name_kk_customers_to_tag (cost=0.00..112.03 rows=3,149 width=0) (actual time=1.085..1.085 rows=3,231 loops=1)

  • Index Cond: ((name)::text = 'PATRIS_KUNDENNUMMER'::text)
5. 0.949 5.135 ↓ 1.0 2,574 1

Hash (cost=811.32..811.32 rows=2,563 width=20) (actual time=5.134..5.135 rows=2,574 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 143kB
6. 3.302 4.186 ↓ 1.0 2,574 1

Bitmap Heap Scan on kk_customers_to_tag ct2 (cost=92.28..811.32 rows=2,563 width=20) (actual time=1.002..4.186 rows=2,574 loops=1)

  • Recheck Cond: ((name)::text = 'PATRIS_KUNDEN_VERTRAGSNUMMER_LEIPZIGMOVE'::text)
  • Heap Blocks: exact=552
7. 0.884 0.884 ↓ 1.0 2,574 1

Bitmap Index Scan on idx_name_kk_customers_to_tag (cost=0.00..91.64 rows=2,563 width=0) (actual time=0.884..0.884 rows=2,574 loops=1)

  • Index Cond: ((name)::text = 'PATRIS_KUNDEN_VERTRAGSNUMMER_LEIPZIGMOVE'::text)
8. 17.964 144.144 ↓ 0.0 0 2,574

Index Scan using customers_pkey on customers c (cost=0.28..54.98 rows=1 width=26) (actual time=0.056..0.056 rows=0 loops=2,574)

  • Index Cond: (customers_id = ct1.customers_id)
  • Filter: ((NOT (alternatives: SubPlan 1 or hashed SubPlan 2)) OR (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)))
  • Rows Removed by Filter: 1
9.          

SubPlan (for Index Scan)

10. 25.740 25.740 ↑ 1.0 1 2,574

Index Scan using idxkk_customers_to_tag_customers_id on kk_customers_to_tag ct (cost=0.29..27.19 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=2,574)

  • Index Cond: (c.customers_id = customers_id)
  • Filter: ((name)::text = 'NEXTBIKE_ID'::text)
  • Rows Removed by Filter: 4
11. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on kk_customers_to_tag ct_1 (cost=87.36..804.91 rows=2,444 width=4) (never executed)

  • Recheck Cond: ((name)::text = 'NEXTBIKE_ID'::text)
12. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_name_kk_customers_to_tag (cost=0.00..86.75 rows=2,444 width=0) (never executed)

  • Index Cond: ((name)::text = 'NEXTBIKE_ID'::text)
13. 100.440 100.440 ↑ 1.0 1 2,511

Index Scan using idxkk_customers_to_tag_customers_id on kk_customers_to_tag ct_2 (cost=0.29..27.19 rows=1 width=0) (actual time=0.040..0.040 rows=1 loops=2,511)

  • Index Cond: (c.customers_id = customers_id)
  • Filter: ((name)::text = 'NEXTBIKE_LOGINKEY'::text)
  • Rows Removed by Filter: 4
14. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on kk_customers_to_tag ct_3 (cost=87.68..805.76 rows=2,486 width=4) (never executed)

  • Recheck Cond: ((name)::text = 'NEXTBIKE_LOGINKEY'::text)
15. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_name_kk_customers_to_tag (cost=0.00..87.06 rows=2,486 width=0) (never executed)

  • Index Cond: ((name)::text = 'NEXTBIKE_LOGINKEY'::text)
Planning time : 1.583 ms
Execution time : 162.462 ms