explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hmlr

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.026 ↓ 0.0 0 1

Limit (cost=8.80..8.80 rows=1 width=36) (actual time=0.026..0.026 rows=0 loops=1)

2. 0.007 0.025 ↓ 0.0 0 1

Sort (cost=8.80..8.82 rows=9 width=36) (actual time=0.024..0.025 rows=0 loops=1)

  • Sort Key: serseq
  • Sort Method: quicksort Memory: 25kB
3. 0.018 0.018 ↓ 0.0 0 1

Index Scan using serasa_20190711_0001 on serasa (cost=0.56..8.75 rows=9 width=36) (actual time=0.017..0.018 rows=0 loops=1)

  • Index Cond: ((serretincval = 1) AND (serretexcval = 0) AND (sercpf = '6260894929'::bigint) AND (serdatretexc = '0001-01-01 00:00:00'::timestamp without time zone))
  • Filter: (serdatretinc <> '0001-01-01 00:00:00'::timestamp without time zone)
Planning time : 0.198 ms
Execution time : 0.060 ms