explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6vQZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.205 0.363 ↑ 5.3 7 1

Hash Right Join (cost=1.22..39.40 rows=37 width=16) (actual time=0.160..0.363 rows=7 loops=1)

  • Hash Cond: (col.addable_column_id = formula.addable_column_id)
2. 0.134 0.134 ↓ 1.0 2,008 1

Seq Scan on ld_addable_cols_live_reports col (cost=0.00..32.90 rows=1,990 width=16) (actual time=0.002..0.134 rows=2,008 loops=1)

3. 0.018 0.024 ↑ 1.0 7 1

Hash (cost=1.13..1.13 rows=7 width=16) (actual time=0.024..0.024 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 0.006 0.006 ↑ 1.0 7 1

Seq Scan on ld_formula formula (cost=0.00..1.13 rows=7 width=16) (actual time=0.004..0.006 rows=7 loops=1)

  • Filter: ((published IS FALSE) AND (id = ANY ('{81056,81059,81060,82575,82580,82583,82634}'::bigint[])))
Planning time : 0.220 ms
Execution time : 0.375 ms