explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4GK

Settings
# exclusive inclusive rows x rows loops node
1. 93.873 7,149.461 ↑ 1.0 10,000 1

Limit (cost=248,729.81..267,905.54 rows=10,000 width=176) (actual time=6,806.913..7,149.461 rows=10,000 loops=1)

2. 435.911 7,055.588 ↑ 2,546.2 110,000 1

Nested Loop (cost=56,972.44..537,127,714.40 rows=280,078,289 width=176) (actual time=3,041.408..7,055.588 rows=110,000 loops=1)

3. 1,446.880 5,959.677 ↑ 2,546.2 110,000 1

Hash Join (cost=56,972.01..15,307,750.22 rows=280,078,289 width=35) (actual time=3,041.378..5,959.677 rows=110,000 loops=1)

  • Hash Cond: (measurement.input_no = input.input_no)
4. 1,472.723 1,472.723 ↑ 229.0 1,254,380 1

Seq Scan on measurement (cost=0.00..7,637,467.88 rows=287,210,688 width=18) (actual time=0.016..1,472.723 rows=1,254,380 loops=1)

5. 1,619.237 3,040.074 ↑ 1.0 1,567,166 1

Hash (cost=26,645.56..26,645.56 rows=1,568,356 width=25) (actual time=3,040.074..3,040.074 rows=1,567,166 loops=1)

  • Buckets: 65,536 Batches: 32 Memory Usage: 3,355kB
6. 1,420.837 1,420.837 ↑ 1.0 1,567,166 1

Seq Scan on input (cost=0.00..26,645.56 rows=1,568,356 width=25) (actual time=0.009..1,420.837 rows=1,567,166 loops=1)

7. 660.000 660.000 ↑ 1.0 1 110,000

Index Scan using report_pkey on report (cost=0.43..1.85 rows=1 width=85) (actual time=0.005..0.006 rows=1 loops=110,000)

  • Index Cond: (report_no = measurement.report_no)
Planning time : 0.573 ms
Execution time : 7,197.050 ms