explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KpNh

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.037 ↓ 0.0 0 1

Hash Join (cost=1.38..2.80 rows=1 width=32) (actual time=0.036..0.037 rows=0 loops=1)

  • Hash Cond: (it."CDATO" = int_s."CDATO")
  • Buffers: shared hit=2
2. 0.015 0.015 ↑ 23.0 1 1

Seq Scan on "INTIMACAO" it (cost=0.00..1.32 rows=23 width=32) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: ("CDSITUACAO" = ANY ('{1,3}'::integer[]))
  • Buffers: shared hit=1
3. 0.001 0.016 ↓ 0.0 0 1

Hash (cost=1.37..1.37 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=1
4. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on "INTIMACAO_SITUACAO" int_s (cost=0.00..1.37 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: ("DTCRIACAO" >= (CURRENT_TIMESTAMP - '00:30:00'::interval))
  • Rows Removed by Filter: 38
  • Buffers: shared hit=1
Planning time : 0.232 ms
Execution time : 0.061 ms