explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zLTn

Settings
# exclusive inclusive rows x rows loops node
1. 0.776 9.502 ↑ 1.0 1,000 1

Limit (cost=0.42..1,695.59 rows=1,000 width=16) (actual time=7.378..9.502 rows=1,000 loops=1)

  • Buffers: shared hit=3167 read=2
  • I/O Timings: read=0.013
2. 8.726 8.726 ↑ 538.9 1,000 1

Index Scan using idx_fact_monitoring_start_file_date on fact_monitoring_start_file c (cost=0.42..913,520.72 rows=538,898 width=16) (actual time=7.376..8.726 rows=1,000 loops=1)

  • Filter: (id_season = 65)
  • Buffers: shared hit=3167 read=2
  • I/O Timings: read=0.013
Planning time : 0.100 ms
Execution time : 9.968 ms