explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ajaA

Settings
# exclusive inclusive rows x rows loops node
1. 29,405.482 29,408.120 ↑ 1.0 1 1

Aggregate (cost=1,470.80..1,476.07 rows=1 width=72) (actual time=29,408.119..29,408.120 rows=1 loops=1)

2. 2.638 2.638 ↑ 1.0 179 1

Index Scan using geometries_pkey on geometries (cost=0.43..1,468.10 rows=179 width=32) (actual time=0.041..2.638 rows=179 loops=1)

  • Index Cond: (id = ANY ('{192254,192296,192338,192380,192411,192438,192472,192251,192339,192376,192412,192441,192466,192490,192510,192252,192297,192340,192377,192621,192622,192627,192633,192641,192647,192645,192648,192650,192651,192657,192659,192660,192666,192664,192378,192665,192669,192668,192671,192672,192492,192255,192300,192343,192379,192415,192443,192468,192245,192682,192533,192542,192556,192566,192580,192303,192344,192384,192416,192444,192470,192495,192517,192555,192586,192306,192349,192386,192265,192307,192348,192387,192266,192308,192392,192420,192448,192269,192311,192351,192389,192421,192449,192474,192496,192273,192316,192358,192394,192356,192398,192426,192454,192477,192501,192274,192319,192357,192277,192360,192395,192278,192325,192359,192283,192535,192550,192559,192570,192323,192363,192399,192430,192459,192480,192505,192522,192562,192587,192324,192457,192282,192326,192365,192403,192431,192537,192549,192563,192571,192581,192286,192330,192368,192401,192434,192462,192482,192292,192331,192370,192404,192435,192461,192486,192506,192523,192288,192554,192561,192573,192616,192631,192637,192639,192369,192652,192654,192656,192406,192440,192460,192289,192335,192371,192290,192543,192551,192332,192372,192409,192436,192465,192487,192507,192526,192294,192337,192375}'::integer[]))