explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gAQ5

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 3,535.697 ↑ 1.0 1 1

Result (cost=1,979.82..1,979.83 rows=1 width=0) (actual time=3,535.697..3,535.697 rows=1 loops=1)

  • Output: 2, $0, 'switch.logmed_2020101309'
  • Buffers: shared hit=245,521
2.          

Initplan (for Result)

3. 0.002 3,535.693 ↓ 0.0 0 1

Limit (cost=0.57..1,979.82 rows=1 width=4) (actual time=3,535.693..3,535.693 rows=0 loops=1)

  • Output: logmed_2020101309.ts_sec
  • Buffers: shared hit=245,521
4. 3,535.691 3,535.691 ↓ 0.0 0 1

Index Scan using src_port_switch_logmed_2020101213 on switch.logmed_2020101309 (cost=0.57..53,440.43 rows=27 width=4) (actual time=3,535.691..3,535.691 rows=0 loops=1)

  • Output: logmed_2020101309.ts_sec
  • Index Cond: ((logmed_2020101309.ts_sec IS NOT NULL) AND (logmed_2020101309.ts_sec >= 1,602,580,818) AND (logmed_2020101309.ts_sec <= 1,602,581,901) AND (logmed_2020101309.src_port = 13,554))
  • Filter: (logmed_2020101309.src_ip = '-1019458764'::integer)
  • Buffers: shared hit=245,521
Planning time : 0.181 ms
Execution time : 3,535.739 ms