explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YfS7

Settings
# exclusive inclusive rows x rows loops node
1. 0.240 0.543 ↓ 1.2 225 1

Bitmap Heap Scan on api_casevisibilityrecord (cost=880.78..1,534.91 rows=181 width=24) (actual time=0.324..0.543 rows=225 loops=1)

  • Recheck Cond: ((instance_id IS NULL) OR (instance_id = ANY ('{262144,262145,262146,262147,262148,262149,262150,262151,262152,262153,262154,262155,262156,262157,262158,262159,262160,262161,262162,262163,262164,262165,262166,262167,262168,262169,262170,262171,262172,262173,262174,262175,262176,262177,262178,262179,262180,262181,262182,262183,262184,262185,262186,262187,262188,262189,262190,262191,262192,262193,262194,262195,262196,262197,262198,262199,262200,262201,262202,262203,262204,262205,262206,262207,262208,262209,262210,262211,262212,262213,262214,262215,262216,262217,262218,262219,262220,262221,262222,262223,262224,262225,262226,262227,262228,262229,262230,262231,262232,262233,262234,262235,262236,262237,262238,262239,262240,262241,262242,262243,262244,262245,262246,262247,262248,262249,262250,262251,262252,262253,262254,262255,262256,262257,262258,262259,262260,262261,262262,262263,262264,262265,262266,262267,262268,262269,262270,262271,262272,262273,262274,262275,262276,262277,262278,262279,262280,262281,262282,262283,262284,262285,262286,262287,262288,262289,262290,262291,262292,262293,262294,262295,262296,262297,262298,262299,262300,262301,262302,262303,262304,262305,262306,262307,262308,262309,262310,262311,262312,262313,262314,262315,262316,262317,262318,262319,262320,262321,262322,262323,262324,262325,262326,262327,262328,262329,262330,262331,262332,262333,262334,262335,262336,262337,262338,262339,262340,262341,262342,262343,262344,262345,262346,262347,262348,262349,262350,262351,262352,262353,262354,262355,262356,262357,262358,262359,262360,262361,262362,262363,262364,262365,262366,262367,262143}'::integer[])))
  • Filter: ((company_id = 56) AND (((instance_id IS NULL) AND (logical_timestamp > 0)) OR (instance_id = ANY ('{262144,262145,262146,262147,262148,262149,262150,262151,262152,262153,262154,262155,262156,262157,262158,262159,262160,262161,262162,262163,262164,262165,262166,262167,262168,262169,262170,262171,262172,262173,262174,262175,262176,262177,262178,262179,262180,262181,262182,262183,262184,262185,262186,262187,262188,262189,262190,262191,262192,262193,262194,262195,262196,262197,262198,262199,262200,262201,262202,262203,262204,262205,262206,262207,262208,262209,262210,262211,262212,262213,262214,262215,262216,262217,262218,262219,262220,262221,262222,262223,262224,262225,262226,262227,262228,262229,262230,262231,262232,262233,262234,262235,262236,262237,262238,262239,262240,262241,262242,262243,262244,262245,262246,262247,262248,262249,262250,262251,262252,262253,262254,262255,262256,262257,262258,262259,262260,262261,262262,262263,262264,262265,262266,262267,262268,262269,262270,262271,262272,262273,262274,262275,262276,262277,262278,262279,262280,262281,262282,262283,262284,262285,262286,262287,262288,262289,262290,262291,262292,262293,262294,262295,262296,262297,262298,262299,262300,262301,262302,262303,262304,262305,262306,262307,262308,262309,262310,262311,262312,262313,262314,262315,262316,262317,262318,262319,262320,262321,262322,262323,262324,262325,262326,262327,262328,262329,262330,262331,262332,262333,262334,262335,262336,262337,262338,262339,262340,262341,262342,262343,262344,262345,262346,262347,262348,262349,262350,262351,262352,262353,262354,262355,262356,262357,262358,262359,262360,262361,262362,262363,262364,262365,262366,262367,262143}'::integer[]))))
  • Rows Removed by Filter: 12
  • Heap Blocks: exact=5
2. 0.002 0.303 ↓ 0.0 0 1

BitmapOr (cost=880.78..880.78 rows=236 width=0) (actual time=0.303..0.303 rows=0 loops=1)

3. 0.009 0.009 ↓ 1.1 12 1

Bitmap Index Scan on api_casevisibilityrecord_instance_id_key (cost=0.00..4.50 rows=11 width=0) (actual time=0.009..0.009 rows=12 loops=1)

  • Index Cond: (instance_id IS NULL)
4. 0.292 0.292 ↑ 1.0 225 1

Bitmap Index Scan on api_casevisibilityrecord_instance_id_key (cost=0.00..876.19 rows=225 width=0) (actual time=0.292..0.292 rows=225 loops=1)

  • Index Cond: (instance_id = ANY ('{262144,262145,262146,262147,262148,262149,262150,262151,262152,262153,262154,262155,262156,262157,262158,262159,262160,262161,262162,262163,262164,262165,262166,262167,262168,262169,262170,262171,262172,262173,262174,262175,262176,262177,262178,262179,262180,262181,262182,262183,262184,262185,262186,262187,262188,262189,262190,262191,262192,262193,262194,262195,262196,262197,262198,262199,262200,262201,262202,262203,262204,262205,262206,262207,262208,262209,262210,262211,262212,262213,262214,262215,262216,262217,262218,262219,262220,262221,262222,262223,262224,262225,262226,262227,262228,262229,262230,262231,262232,262233,262234,262235,262236,262237,262238,262239,262240,262241,262242,262243,262244,262245,262246,262247,262248,262249,262250,262251,262252,262253,262254,262255,262256,262257,262258,262259,262260,262261,262262,262263,262264,262265,262266,262267,262268,262269,262270,262271,262272,262273,262274,262275,262276,262277,262278,262279,262280,262281,262282,262283,262284,262285,262286,262287,262288,262289,262290,262291,262292,262293,262294,262295,262296,262297,262298,262299,262300,262301,262302,262303,262304,262305,262306,262307,262308,262309,262310,262311,262312,262313,262314,262315,262316,262317,262318,262319,262320,262321,262322,262323,262324,262325,262326,262327,262328,262329,262330,262331,262332,262333,262334,262335,262336,262337,262338,262339,262340,262341,262342,262343,262344,262345,262346,262347,262348,262349,262350,262351,262352,262353,262354,262355,262356,262357,262358,262359,262360,262361,262362,262363,262364,262365,262366,262367,262143}'::integer[]))
Planning time : 0.730 ms
Execution time : 0.661 ms