explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WAVK

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.061 ↓ 0.0 0 1

Delete on client (cost=0.45..3.49 rows=1 width=34) (actual time=0.061..0.061 rows=0 loops=1)

  • Buffers: shared hit=5 dirtied=1
2. 0.004 0.058 ↓ 0.0 0 1

Nested Loop (cost=0.45..3.49 rows=1 width=34) (actual time=0.058..0.058 rows=0 loops=1)

  • Buffers: shared hit=5 dirtied=1
3. 0.006 0.032 ↑ 1.0 1 1

HashAggregate (cost=0.03..0.04 rows=1 width=32) (actual time=0.031..0.032 rows=1 loops=1)

  • Group Key: "ANY_subquery".cid
  • Buffers: shared hit=1
4. 0.005 0.026 ↑ 1.0 1 1

Subquery Scan on ANY_subquery (cost=0.00..0.02 rows=1 width=32) (actual time=0.025..0.026 rows=1 loops=1)

  • Buffers: shared hit=1
5. 0.001 0.021 ↑ 1.0 1 1

Limit (cost=0.00..0.01 rows=1 width=4) (actual time=0.021..0.021 rows=1 loops=1)

  • Buffers: shared hit=1
6. 0.020 0.020 ↑ 1,313,238.0 1 1

Seq Scan on tmp_client_ids (cost=0.00..18,945.38 rows=1,313,238 width=4) (actual time=0.020..0.020 rows=1 loops=1)

  • Buffers: shared hit=1
7. 0.022 0.022 ↓ 0.0 0 1

Index Scan using clientpk on client (cost=0.43..3.45 rows=1 width=10) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (id = "ANY_subquery".cid)
  • Buffers: shared hit=4 dirtied=1
Planning time : 0.590 ms
Execution time : 0.234 ms