explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LZk

Settings
# exclusive inclusive rows x rows loops node
1. 0.105 5,264.094 ↑ 1.5 59 1

Limit (cost=326,535.20..326,594.43 rows=87 width=126) (actual time=5,261.619..5,264.094 rows=59 loops=1)

2. 2.677 5,263.989 ↑ 1.5 59 1

Hash Join (cost=326,535.20..326,594.43 rows=87 width=126) (actual time=5,261.616..5,263.989 rows=59 loops=1)

  • Hash Cond: ((gr.tetrad)::text = (o.tetrad)::text)
3. 1.903 1.903 ↑ 1.0 1,756 1

Seq Scan on mvw_erccis_grid_refs gr (cost=0.00..51.56 rows=1,756 width=126) (actual time=0.009..1.903 rows=1,756 loops=1)

4. 0.079 5,259.409 ↑ 1.5 59 1

Hash (cost=326,534.11..326,534.11 rows=87 width=6) (actual time=5,259.409..5,259.409 rows=59 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
5. 0.145 5,259.330 ↑ 1.5 59 1

HashAggregate (cost=326,532.37..326,533.24 rows=87 width=6) (actual time=5,259.265..5,259.330 rows=59 loops=1)

6. 239.111 5,259.185 ↑ 1.5 59 1

HashAggregate (cost=326,531.28..326,532.15 rows=87 width=6) (actual time=5,259.123..5,259.185 rows=59 loops=1)

7. 4,872.707 5,020.074 ↑ 1.6 143,102 1

Bitmap Heap Scan on erccis_summary_occurrences o (cost=21,490.19..325,951.31 rows=231,990 width=6) (actual time=149.460..5,020.074 rows=143,102 loops=1)

  • Recheck Cond: (tetrad_geom && '0106000020110F00000200000001030000000100000006000000F7EC778CC2481EC13CB68AECE3F558411B91185E6ABB1EC12D3A7E01A6E958417653CA9FFC181EC120C88B9392E45841229BF5D3FF971DC199A6E33024EB5841FDAF29CE54A61DC12A5F062DB2F45841F7EC778CC2481EC13CB68AECE3F5584101030000000100000004000000D5528A4BBD5320C1FB1983142FE258414490FFA173BA20C1FEF4FAE822D75841CC292257133720C15600C2DB44D05841D5528A4BBD5320C1FB1983142FE25841'::geometry)
  • Rows Removed by Index Recheck: 1989152
  • Filter: _st_intersects(tetrad_geom, '0106000020110F00000200000001030000000100000006000000F7EC778CC2481EC13CB68AECE3F558411B91185E6ABB1EC12D3A7E01A6E958417653CA9FFC181EC120C88B9392E45841229BF5D3FF971DC199A6E33024EB5841FDAF29CE54A61DC12A5F062DB2F45841F7EC778CC2481EC13CB68AECE3F5584101030000000100000004000000D5528A4BBD5320C1FB1983142FE258414490FFA173BA20C1FEF4FAE822D75841CC292257133720C15600C2DB44D05841D5528A4BBD5320C1FB1983142FE25841'::geometry)
  • Rows Removed by Filter: 642066
8. 147.367 147.367 ↓ 1.1 785,168 1

Bitmap Index Scan on ix_erccis_summary_occurrences_tetrad_geom (cost=0.00..21,432.19 rows=695,970 width=0) (actual time=147.367..147.367 rows=785,168 loops=1)

  • Index Cond: (tetrad_geom && '0106000020110F00000200000001030000000100000006000000F7EC778CC2481EC13CB68AECE3F558411B91185E6ABB1EC12D3A7E01A6E958417653CA9FFC181EC120C88B9392E45841229BF5D3FF971DC199A6E33024EB5841FDAF29CE54A61DC12A5F062DB2F45841F7EC778CC2481EC13CB68AECE3F5584101030000000100000004000000D5528A4BBD5320C1FB1983142FE258414490FFA173BA20C1FEF4FAE822D75841CC292257133720C15600C2DB44D05841D5528A4BBD5320C1FB1983142FE25841'::geometry)"Total runtime: 5264.225 ms