explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zmeq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 980.028 ↓ 1.2 62,135 1

Gather Merge (cost=82,346.41..88,260.19 rows=50,686 width=617) (actual time=911.325..980.028 rows=62,135 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 163.383 2,621.631 ↑ 1.2 20,712 3

Sort (cost=81,346.39..81,409.74 rows=25,343 width=617) (actual time=867.962..873.877 rows=20,712 loops=3)

  • Sort Key: measuringp0_.valid_from DESC
  • Sort Method: external merge Disk: 6880kB
3. 52.770 2,458.248 ↑ 1.2 20,712 3

Nested Loop Left Join (cost=31,252.16..72,475.13 rows=25,343 width=617) (actual time=514.115..819.416 rows=20,712 loops=3)

4. 42.771 2,219.073 ↑ 1.2 20,712 3

Hash Left Join (cost=31,251.73..53,806.30 rows=25,343 width=515) (actual time=514.086..739.691 rows=20,712 loops=3)

  • Hash Cond: (measuringp0_.measurement_fk = measuremen3_.id)
5. 376.758 1,973.037 ↑ 1.2 20,712 3

Hash Join (cost=28,057.99..46,577.60 rows=25,343 width=422) (actual time=446.117..657.679 rows=20,712 loops=3)

  • Hash Cond: (measuringp1_.id = measuringp0_.measuring_point_fk)
6. 348.789 915.618 ↑ 1.3 20,712 3

Hash Join (cost=13,731.58..25,235.11 rows=26,834 width=371) (actual time=217.216..305.206 rows=20,712 loops=3)

  • Hash Cond: (measuringp1_.location_fk = location4_.id)
7. 111.798 111.798 ↑ 1.3 116,837 3

Parallel Seq Scan on measuring_point measuringp1_ (cost=0.00..5,277.23 rows=146,123 width=53) (actual time=0.014..37.266 rows=116,837 loops=3)

8. 187.782 455.031 ↑ 1.0 60,256 3

Hash (cost=10,414.89..10,414.89 rows=60,855 width=318) (actual time=151.677..151.677 rows=60,256 loops=3)

  • Buckets: 16384 Batches: 8 Memory Usage: 1354kB
9. 75.102 267.249 ↑ 1.0 60,256 3

Nested Loop (cost=0.15..10,414.89 rows=60,855 width=318) (actual time=0.079..89.083 rows=60,256 loops=3)

10. 0.069 0.069 ↑ 1.0 1 3

Index Scan using grid_pkey on grid grid5_ (cost=0.15..8.17 rows=1 width=103) (actual time=0.021..0.023 rows=1 loops=3)

  • Index Cond: (id = 3084)
11. 192.078 192.078 ↑ 1.0 60,256 3

Seq Scan on location location4_ (cost=0.00..9,798.17 rows=60,855 width=215) (actual time=0.053..64.026 rows=60,256 loops=3)

  • Filter: (grid_fk = 3084)
  • Rows Removed by Filter: 275956
12. 388.941 680.661 ↓ 1.0 332,845 3

Hash (cost=6,951.30..6,951.30 rows=331,209 width=51) (actual time=226.887..226.887 rows=332,845 loops=3)

  • Buckets: 65536 Batches: 16 Memory Usage: 1937kB
13. 291.720 291.720 ↓ 1.0 332,845 3

Seq Scan on measuring_point_target measuringp0_ (cost=0.00..6,951.30 rows=331,209 width=51) (actual time=0.063..97.240 rows=332,845 loops=3)

  • Filter: ((valid_from IS NOT NULL) AND (valid_to IS NULL))
  • Rows Removed by Filter: 46485
14. 125.205 203.265 ↑ 1.0 64,344 3

Hash (cost=1,446.44..1,446.44 rows=64,344 width=93) (actual time=67.755..67.755 rows=64,344 loops=3)

  • Buckets: 32768 Batches: 4 Memory Usage: 1870kB
15. 78.060 78.060 ↑ 1.0 64,344 3

Seq Scan on measurement measuremen3_ (cost=0.00..1,446.44 rows=64,344 width=93) (actual time=0.042..26.020 rows=64,344 loops=3)

16. 186.405 186.405 ↑ 1.0 1 62,135

Index Scan using register_pkey on register register2_ (cost=0.43..0.74 rows=1 width=102) (actual time=0.003..0.003 rows=1 loops=62,135)

  • Index Cond: (measuringp0_.register_fk = id)
Planning time : 2.175 ms
Execution time : 989.679 ms