explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SyAj

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 18,076.228 ↓ 0.0 0 1

Limit (cost=0.44..71,795.71 rows=100 width=16) (actual time=18,076.228..18,076.228 rows=0 loops=1)

  • Buffers: shared hit=11755187 read=965863
2. 0.001 18,076.227 ↓ 0.0 0 1

Nested Loop (cost=0.44..28,718,828.22 rows=40,001 width=16) (actual time=18,076.227..18,076.227 rows=0 loops=1)

  • Buffers: shared hit=11755187 read=965863
3. 0.000 18,076.226 ↓ 0.0 0 1

Nested Loop (cost=0.44..28,608,997.61 rows=40,001 width=32) (actual time=18,076.226..18,076.226 rows=0 loops=1)

  • Buffers: shared hit=11755187 read=965863
4. 1,183.243 18,076.226 ↓ 0.0 0 1

Nested Loop (cost=0.44..28,608,496.4 rows=40,001 width=40) (actual time=18,076.226..18,076.226 rows=0 loops=1)

  • Buffers: shared hit=11755187 read=965863
5. 15,981.166 15,981.166 ↑ 1.0 911,817 1

Index Scan using data_files_001_inference_time_index on data_files_001 datafile0_ (cost=0.44..28,498,087.55 rows=920,016 width=32) (actual time=11,614.897..15,981.166 rows=911,817 loops=1)

  • Filter: (datafile0_.dataset_id = 3)
  • Buffers: shared hit=11755187 read=965859
6. 911.738 911.817 ↑ 1.0 8 911,817

Materialize (cost=0..6.96 rows=8 width=8) (actual time=0..0.001 rows=8 loops=911,817)

  • Buffers: shared read=4
7. 0.005 0.079 ↑ 1.0 8 1

Nested Loop (cost=0..6.92 rows=8 width=8) (actual time=0.039..0.079 rows=8 loops=1)

  • Buffers: shared read=4
8. 0.032 0.032 ↑ 1.0 1 1

Seq Scan on variables variable5_ (cost=0..2.54 rows=1 width=4) (actual time=0.022..0.032 rows=1 loops=1)

  • Filter: (variable5_.id = 1)
  • Buffers: shared read=2
9. 0.042 0.042 ↑ 1.0 8 1

Seq Scan on file_metadata_to_variable variables4_ (cost=0..4.3 rows=8 width=16) (actual time=0.014..0.042 rows=8 loops=1)

  • Filter: (variables4_.variable_id = 1)
  • Buffers: shared read=2
10. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0..1.19 rows=1 width=4) (never executed)

11. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on datasets dataset2_ (cost=0..1.19 rows=1 width=4) (never executed)

  • Filter: (dataset2_.id = 3)
12. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0..20.76 rows=184 width=8) (never executed)

13. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on file_metadata filemetada3_ (cost=0..19.84 rows=184 width=8) (never executed)

Planning time : 1.579 ms
Execution time : 18,076.285 ms