explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OCJ

Settings
# exclusive inclusive rows x rows loops node
1. 669.093 43,370.398 ↓ 762.4 762,385 1

Nested Loop Left Join (cost=0.93..2,558.70 rows=1,000 width=48) (actual time=39,581.499..43,370.398 rows=762,385 loops=1)

2. 39,651.765 39,651.765 ↓ 762.4 762,385 1

Function Scan on clickhouse_make_query_post ch (cost=0.50..10.50 rows=1,000 width=44) (actual time=39,581.450..39,651.765 rows=762,385 loops=1)

3. 3,049.540 3,049.540 ↑ 1.0 1 762,385

Index Scan using placements_pkey on placements pl (cost=0.43..2.55 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=762,385)

  • Index Cond: (ch.id_placement = id)
Planning time : 0.969 ms
Execution time : 43,417.804 ms